On Thu, Apr 10, 2008 at 11:29 PM, Dennis Brakhane
<brakhane@googlemail.com> 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