Re: [GENERAL] ON CONFLICT does not support deferrable unique constraints

2016-08-25 Thread Peter Geoghegan
On Thu, Aug 25, 2016 at 12:29 AM, Francisco Olarte wrote: > That been said, I'm not sure making it ( deferred constraint act like > immediate ones during upserts ) work is even a good idea. If it can be > conditionally enabled with a simple set and implemented in very few ( > < 20 ) lines of code,

Re: [GENERAL] ON CONFLICT does not support deferrable unique constraints

2016-08-25 Thread Francisco Olarte
On Wed, Aug 24, 2016 at 9:22 PM, Andreas Joseph Krogh wrote: > As a developer I want it to "just work", if there's an error of any kind then > abort the transaction, just as it was non-deferrable. Everybody wants everything to "just work", for their own ( in a lot of cases unspecified even to th

Re: [GENERAL] ON CONFLICT does not support deferrable unique constraints

2016-08-24 Thread Andreas Joseph Krogh
På onsdag 24. august 2016 kl. 18:36:16, skrev Francisco Olarte < fola...@peoplecall.com >: On Wed, Aug 24, 2016 at 6:26 PM, Scott Marlowe wrote: > On Wed, Aug 24, 2016 at 6:05 AM, Andreas Joseph Krogh >> Are there any plans to lift this restriction? > I'm trying t

Re: [GENERAL] ON CONFLICT does not support deferrable unique constraints

2016-08-24 Thread Francisco Olarte
On Wed, Aug 24, 2016 at 6:26 PM, Scott Marlowe wrote: > On Wed, Aug 24, 2016 at 6:05 AM, Andreas Joseph Krogh >> Are there any plans to lift this restriction? > I'm trying to figure out a method for making this work in my head. > These two things seem kind of opposed to each other. He probably wa

Re: [GENERAL] ON CONFLICT does not support deferrable unique constraints

2016-08-24 Thread Scott Marlowe
On Wed, Aug 24, 2016 at 6:05 AM, Andreas Joseph Krogh wrote: > > Hope some -hackers read this... > > Are there any plans to lift this restriction? I'm trying to figure out a method for making this work in my head. These two things seem kind of opposed to each other. -- Sent via pgsql-general m

[GENERAL] ON CONFLICT does not support deferrable unique constraints

2016-08-24 Thread Andreas Joseph Krogh
Hope some -hackers read this...   Are there any plans to lift this restriction?   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com www.visena.com