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.