Re: [HACKERS] Deferred partial/expression unique constraints

2011-07-26 Thread Robert Haas
On Mon, Jul 25, 2011 at 2:29 PM, Jeff Davis pg...@j-davis.com 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

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 representable in

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 dean.a.rash...@gmail.com 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

Re: [HACKERS] Deferred partial/expression unique constraints

2011-07-13 Thread Dean Rasheed
On 13 July 2011 01:23, Andres Freund and...@anarazel.de wrote: On Tuesday, July 12, 2011 08:57:44 PM Dean Rasheed wrote: On 12 July 2011 19:26, Josh Berkus j...@agliodbs.com wrote: On 7/12/11 9:46 AM, Andres Freund wrote: Hi, I guess $subject wasn't implemented because plain unique

Re: [HACKERS] Deferred partial/expression unique constraints

2011-07-13 Thread Tom Lane
Dean Rasheed dean.a.rash...@gmail.com 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

[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

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

Re: [HACKERS] Deferred partial/expression unique constraints

2011-07-12 Thread Dean Rasheed
On 12 July 2011 19:26, Josh Berkus j...@agliodbs.com 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

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 j...@agliodbs.com 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