RE: Primary Key Update issue ?

[Andreas Joseph Krogh <andreas@xxxxxxxxxx>]

På fredag 06. september 2019 kl. 11:25:36, skrev Patrick FICHE <Patrick.Fiche@xxxxxxxxxxx>:

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

andreas@xxxxxxxxxx

www.visena.com