Re: [HACKERS] Deferred partial/expression unique constraints

2011-07-26 Thread Robert Haas
On Mon, Jul 25, 2011 at 2:29 PM, Jeff Davis wrote: > On Fri, 2011-07-22 at 23:35 +0300, Peter Eisentraut wrote: >> On ons, 2011-07-13 at 11:26 -0400, Tom Lane wrote: >> > Our standard reason for not implementing UNIQUE constraints on >> > expressions has been that then you would have a thing that

Re: [HACKERS] Deferred partial/expression unique constraints

2011-07-25 Thread Jeff Davis
On Fri, 2011-07-22 at 23:35 +0300, Peter Eisentraut wrote: > On ons, 2011-07-13 at 11:26 -0400, Tom Lane wrote: > > Our standard reason for not implementing UNIQUE constraints on > > expressions has been that then you would have a thing that claims to be > > a UNIQUE constraint but isn't representa

Re: [HACKERS] Deferred partial/expression unique constraints

2011-07-22 Thread Peter Eisentraut
On ons, 2011-07-13 at 11:26 -0400, Tom Lane wrote: > Dean Rasheed writes: > >>> On 7/12/11 9:46 AM, Andres Freund wrote: > I guess $subject wasn't implemented because plain unique indexes aren't > represented in pg_constraint and thus do not have a place to store > information about

Re: [HACKERS] Deferred partial/expression unique constraints

2011-07-13 Thread Tom Lane
Dean Rasheed writes: >>> On 7/12/11 9:46 AM, Andres Freund wrote: I guess $subject wasn't implemented because plain unique indexes aren't represented in pg_constraint and thus do not have a place to store information about being deferred? > I agree that expressing that using a UNIQ

Re: [HACKERS] Deferred partial/expression unique constraints

2011-07-13 Thread Dean Rasheed
On 13 July 2011 01:23, Andres Freund wrote: > On Tuesday, July 12, 2011 08:57:44 PM Dean Rasheed wrote: >> On 12 July 2011 19:26, Josh Berkus wrote: >> > On 7/12/11 9:46 AM, Andres Freund wrote: >> >> Hi, >> >> >> >> I guess $subject wasn't implemented because plain unique indexes aren't >> >> re

Re: [HACKERS] Deferred partial/expression unique constraints

2011-07-12 Thread Andres Freund
On Tuesday, July 12, 2011 08:57:44 PM Dean Rasheed wrote: > On 12 July 2011 19:26, Josh Berkus wrote: > > On 7/12/11 9:46 AM, Andres Freund wrote: > >> Hi, > >> > >> I guess $subject wasn't implemented because plain unique indexes aren't > >> represented in pg_constraint and thus do not have a pl

Re: [HACKERS] Deferred partial/expression unique constraints

2011-07-12 Thread Dean Rasheed
On 12 July 2011 19:26, Josh Berkus wrote: > On 7/12/11 9:46 AM, Andres Freund wrote: >> Hi, >> >> I guess $subject wasn't implemented because plain unique indexes aren't >> represented in pg_constraint and thus do not have a place to store >> information >> about being deferred? >> Other than tha

Re: [HACKERS] Deferred partial/expression unique constraints

2011-07-12 Thread Josh Berkus
On 7/12/11 9:46 AM, Andres Freund wrote: > Hi, > > I guess $subject wasn't implemented because plain unique indexes aren't > represented in pg_constraint and thus do not have a place to store > information > about being deferred? > Other than that I do not see any special complications in imple

[HACKERS] Deferred partial/expression unique constraints

2011-07-12 Thread Andres Freund
Hi, I guess $subject wasn't implemented because plain unique indexes aren't represented in pg_constraint and thus do not have a place to store information about being deferred? Other than that I do not see any special complications in implementing it? Is there any reasons not to store unique in