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

Re: Deferrable UNIQUE INDEX?

From: David Fetter <david(at)fetter(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Deferrable UNIQUE INDEX?
Date: 2006-01-04 04:34:04
Message-ID: 20060104043404.GD27483@fetter.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, Jan 03, 2006 at 11:17:16PM -0500, Tom Lane wrote:
> "Andrew Dunstan" <andrew(at)dunslane(dot)net> writes:
> > David Fetter said:
> >> Is there some way to make the index check INITIALLY DEFERRABLE
> >> the way a regular column/table constraint could be?
> 
> > The TODO list has: "Allow DEFERRABLE UNIQUE constraints?" send in
> > a patch ;-)
> 
> This is definitely on the wish-list, because it is both useful and
> required by the SQL spec ... but it seems nontrivial.  I recall some
> discussions in the pghackers archives about how to do it.

There was some discussion in the followups to this posting:

http://archives.postgresql.org/pgsql-hackers/2005-01/msg00882.php

Alvaro mentioned a strategy here

http://archives.postgresql.org/pgsql-hackers/2005-01/msg00904.php

and the "tough part" appears to have come down to "disk-spilling
logic."

I'm out of my depth here, but maybe we could figure out just what
components would need to be touched and how...

Cheers,
D
-- 
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 415 235 3778

Remember to vote!

In response to

pgsql-hackers by date

Next:From: davegDate: 2006-01-04 06:37:56
Subject: Re: TRUNCATE, VACUUM, ANALYZE privileges
Previous:From: Tom LaneDate: 2006-01-04 04:32:01
Subject: Re: TRUNCATE, VACUUM, ANALYZE privileges

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