Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same
Date
Msg-id 18397.1281104068@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same  ("Frank Heikens" <f.heikens@anva.nl>)
Responses Re: BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same
List pgsql-bugs
Tree view 
"Frank Heikens" <f.heikens@anva.nl> writes:
> Description:        DEFERRABLE and  DEFERRABLE INITIALLY DEFERRED are the
> same

This test proves no such thing.  You are supposing that a deferrable
unique index has the exact same behavior as a nondeferrable one.
Actually, a DEFERRABLE IMMEDIATE index enforces its checks as of the end
of the statement, which is per spec.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Frank Heikens"
Date:
Subject: BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same
Next
From: "Marcelo Mas"
Date:
Subject: BUG #5607: memmory leak in ecpg