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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
