Re: Deferrable UNIQUE INDEX?

From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
To: <david(at)fetter(dot)org>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Deferrable UNIQUE INDEX?
Date: 2006-01-04 02:33:41
Message-ID: 4995.24.211.165.134.1136342021.squirrel@www.dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

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