Message-ID: <8234056e-9d60-2a41-1701-1afb08e330db@jakobs.com>
Date: Thu, 11 May 2023 17:09:45 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.10.0
Subject: Re: nextval() on serial using old, existing value on insert?
Content-Language: de-DE
To: pgsql-admin@lists.postgresql.org
References: 
 <CAOC+FBWAzy8MDbwE2XJGsi8eV=QCuSS8orgAEdyOLr37_Z4ByQ@mail.gmail.com>
 <CAKFQuwaV9z4xUoxaqLx0_-7UjaafWX3O0=1Rsu4EDi87PTxUrQ@mail.gmail.com>
 <CAOC+FBWNpEvA9mSj3_wfhc2PPpeEr5BBshaN4trbXvgPgep0wQ@mail.gmail.com>
 <CAOC+FBVz0MhyA4oUwEHbtvCVQV-Hh9n1esA-1OMMt=N6LZb_Vw@mail.gmail.com>
 <ZFzhvT/4cvUTRlF2@depesz.com>
From: Holger Jakobs <holger@jakobs.com>
In-Reply-To: <ZFzhvT/4cvUTRlF2@depesz.com>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="------------ExvBBnPPrXGjA4TTFhVlTO2s"
Archived-At: 
 <https://www.postgresql.org/message-id/8234056e-9d60-2a41-1701-1afb08e330db%40jakobs.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------------ExvBBnPPrXGjA4TTFhVlTO2s
Content-Type: multipart/mixed; boundary="------------My4cNmXs4l757GdoLeiNhSAX";
 protected-headers="v1"
From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Message-ID: <8234056e-9d60-2a41-1701-1afb08e330db@jakobs.com>
Subject: Re: nextval() on serial using old, existing value on insert?
References: <CAOC+FBWAzy8MDbwE2XJGsi8eV=QCuSS8orgAEdyOLr37_Z4ByQ@mail.gmail.com>
 <CAKFQuwaV9z4xUoxaqLx0_-7UjaafWX3O0=1Rsu4EDi87PTxUrQ@mail.gmail.com>
 <CAOC+FBWNpEvA9mSj3_wfhc2PPpeEr5BBshaN4trbXvgPgep0wQ@mail.gmail.com>
 <CAOC+FBVz0MhyA4oUwEHbtvCVQV-Hh9n1esA-1OMMt=N6LZb_Vw@mail.gmail.com>
 <ZFzhvT/4cvUTRlF2@depesz.com>
In-Reply-To: <ZFzhvT/4cvUTRlF2@depesz.com>

--------------My4cNmXs4l757GdoLeiNhSAX
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: base64

QW0gMTEuMDUuMjMgdW0gMTQ6Mzggc2NocmllYiBodWJlcnQgZGVwZXN6IGx1YmFjemV3c2tp
Og0KPiBPbiBXZWQsIE1heSAxMCwgMjAyMyBhdCAxMDowNjoyOFBNIC0wNzAwLCBXZWxscyBP
bGl2ZXIgd3JvdGU6DQo+PiBBcyBhIGZvbGxvdyB1cCwgSSd2ZSBzZWxlY3RlZCBtYXgoY29t
bW9uX2tleSkgZnJvbSB0aGUgdGFibGUgYW5kDQo+PiBzZXR2YWwoKSdlZCBvbiB0aGUgc2Vx
dWVuY2UgdG8gdGhhdCArMSBhbmQgSSB0aGluayB0aGF0IHNob3VsZCBtYWtlIHRoaXMgZ28N
Cj4+IGF3YXkuIEFueSByZWFzb24gd2h5IHRoYXQncyBpbnNhbmU/DQo+IElmIHlvdSdyZSBv
biBwZyAxMCBvciBuZXdlciwgeW91IGNhbiBtYWtlIHRoZSBpZCB0byBiZSAiZ2VuZXJhdGVk
IGFsd2F5cw0KPiBhcyBpZGVudGl0eSIgd2hpY2ggd2lsbCBtYWtlIGl0IGltcG9zc2libGUg
dG8gcHJvdmlkZSBpZCB2YWx1ZSBmcm9tDQo+IHVzZXIsIHRodXMgbWFraW5nIHRoZSBwcm9i
bGVtIGltcG9zc2libGUgdG8gaGFwcGVuLg0KPg0KPiBCZXN0IHJlZ2FyZHMsDQo+DQo+IGRl
cGVzeg0KDQpJbXBvc3NpYmxlIHRvIGhhcHBlbiBieSBjaGFuY2UuIEEgbWFsaWNpb3VzIHVz
ZXIgY291bGQgYWx3YXlzIHVzZSANCk9WRVJSSURJTkcgU1lTVEVNIFZBTFVFIGNsYXVzZS4N
Cg0KS2luZCBSZWdhcmRzLA0KDQpIb2xnZXINCg0KLS0gDQpIb2xnZXIgSmFrb2JzLCBCZXJn
aXNjaCBHbGFkYmFjaCwgVGVsLiArNDktMTc4LTk3NTkwMTINCg0K

--------------My4cNmXs4l757GdoLeiNhSAX--

--------------ExvBBnPPrXGjA4TTFhVlTO2s
Content-Type: application/pgp-signature; name="OpenPGP_signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="OpenPGP_signature"

-----BEGIN PGP SIGNATURE-----

wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCZF0FOQUDAAAAAAAKCRCKV5yTsxlhuspH
AKDfKBhhPdafOY7oYMY033Lw+AbhcgCgj/pC8hjXmSRAidkCrDA4M7Fw3aA=
=L1hC
-----END PGP SIGNATURE-----

--------------ExvBBnPPrXGjA4TTFhVlTO2s--