Re: BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Frank Heikens" <f(dot)heikens(at)anva(dot)nl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same
Date: 2010-08-06 14:14:28
Message-ID: 18397.1281104068@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Frank Heikens" <f(dot)heikens(at)anva(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Marcelo Mas 2010-08-06 14:39:28 BUG #5607: memmory leak in ecpg
Previous Message Frank Heikens 2010-08-06 11:10:13 BUG #5606: DEFERRABLE and DEFERRABLE INITIALLY DEFERRED are the same