Re: Deferrable UNIQUE INDEX? - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Deferrable UNIQUE INDEX?
Date
Msg-id 4995.24.211.165.134.1136342021.squirrel@www.dunslane.net
Whole thread Raw
In response to Deferrable UNIQUE INDEX?  (David Fetter <david@fetter.org>)
Responses Re: Deferrable UNIQUE INDEX?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
David Fetter said:

> Is there some way to make the index check INITIALLY DEFERRABLE the way
> a regular column/table constraint could be?
>
> I'd much appreciate any insights into this :)
>

The docs say: "Only foreign key constraints currently accept this clause.
All other constraint types are not deferrable."

The TODO list has: "Allow DEFERRABLE UNIQUE constraints?"

send in a patch ;-)

cheers

andrew




pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Deferrable UNIQUE INDEX?
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: Inconsistent syntax in GRANT