On Mon, Mar 22, 2004 at 17:21:21 +0100,
Erik Thiele <erik@thiele-hydraulik.de> wrote:
>
> there is no such thing as a deferred check constraint:
>
> 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 may 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. !!!
Sorry, I checked the syntax for CREATE TABLE in the documentation and
it shows DEFERRABLE as allowed on any column constraint. However, that
is apparently not correct.