Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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 ;-)



In response to


pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group