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

Osvaldo Kussama wrote on 25.01.2009 15:24:
> See the manual:
> http://www.postgresql.org/docs/current/interactive/sql-createtable.html
> "DEFERRABLE
> NOT DEFERRABLE
>
>     This controls whether the constraint can be deferred. A constraint
> that is not deferrable will be checked immediately after every
> command. Checking of constraints that are deferrable can be postponed
> until the end of the transaction (using the SET CONSTRAINTS command).
> NOT DEFERRABLE is the default. *Only foreign key constraints currently
> accept this clause. All other constraint types are not deferrable.*"
>

Thanks for reading the manual for me :)

Maybe the syntax definition for the /column_constraint/ part should be reworked
to make that clearer, by e.g. putting the DEFERRED stuff in to the "choice" for
FK definitions not at the end where it is "legal" for any constraint.

Regards
Thomas