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

In response to

• Deferrable UNIQUE INDEX? at 2006-01-04 01:45:13 from David Fetter

Responses

• Re: Deferrable UNIQUE INDEX? at 2006-01-04 04:17:16 from Tom Lane

pgsql-hackers by date

Next:	From: Zach Bagnall	Date: 2006-01-04 03:41:43
	Subject: Re: Incremental Backup Script
Previous:	From: Michael Glaesemann	Date: 2006-01-04 02:20:43
	Subject: Re: Deferrable UNIQUE INDEX?