From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
---|---|
To: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: ON CONFLICT does not support deferrable unique constraints |
Date: | 2016-08-25 07:29:47 |
Message-ID: | CA+bJJbz_XRAgfc=6bsuzMtO6iynOoqDDCL1UHiW1mzrcWUkd-Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Aug 24, 2016 at 9:22 PM, Andreas Joseph Krogh
<andreas(at)visena(dot)com> 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 the themselves ) definition of JW.
Developers normally want to be told what "just work" means when
developing something.
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, ok for me , otherwise I would prefer the reduced
bug surface.
Francisco Olarte.
From | Date | Subject | |
---|---|---|---|
Next Message | Russell Keane | 2016-08-25 08:50:54 | corruption in indexes under heavy load |
Previous Message | Alexander Farber | 2016-08-25 06:38:44 | Re: Forward declaration of table |