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: 4995.24.211.165.134.1136342021.squirrel@www.dunslane.net (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group