RE: Primary Key Update issue ? - Mailing list pgsql-general
På fredag 06. september 2019 kl. 11:25:36, skrev Patrick FICHE <Patrick.Fiche@aqsacom.com>:
Hi Andreas,
Thanks a lot for your answer, which solves this case.
I was still a bit surprised as this is linked to transaction management while I have here a single statement until I saw the Compatibility Remark in documentation : Also, PostgreSQL checks non-deferrable uniqueness constraints immediately, not at end of statement as the standard would suggest.
FWIW - PostgreSQL behaves like Oracle in this regard.
-- 
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
Attachment
pgsql-general by date: