On Thu, Apr 10, 2008 at 11:29 PM, Dennis Brakhane <brakhane@xxxxxxxxxxxxxx> wrote: > > I believe it does. See > http://www.postgresql.org/docs/8.3/interactive/sql-set-constraints.html > and the DEFERRABLE keyword in CREATE TABLE. > > Or am I missing something here? > Only foreign key contrains checks (and triggers) can be deferred, not the primary or unique key checks. See the following statement in the same doc page: "Currently, only foreign key constraints are affected by this setting. Check and unique constraints are always effectively not deferrable. Triggers that are declared as "constraint triggers" are also affected." Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com
