Re: Problem defining deferred check constraints - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Problem defining deferred check constraints
Date
Msg-id 20090125091913.B38711@megazone.bigpanda.com
Whole thread Raw
In response to Problem defining deferred check constraints  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
On Sun, 25 Jan 2009, Thomas Kellerer wrote:

> Hi,
>
> I'm playing around with deferred constraints and according to the manual, it
> should be possible to declare a check constraint as deferred.
>
> At least that's how I read the definition of /column_constraint/ at
> http://www.postgresql.org/docs/8.3/static/sql-createtable.html

In the full description in that page for deferrable/not deferrable, it
also states: "Only foreign key constraints currently accept this clause."

Currently, you'd probably need to use a constraint trigger to check the
constraint to get similar functionality.


pgsql-general by date:

Previous
From: Roger Leigh
Date:
Subject: Re: Custom type, operators and operator class not sorting/indexing correctly
Next
From: Raymond O'Donnell
Date:
Subject: Re: autovacuum daemon