Search Postgresql Archives

Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence
From: Karsten Hilbert <Karsten.Hilbert@xxxxxxx>
Date: Wed, 20 Jul 2022 11:33:25 +0200
Di_x_sposition-notification-to: Karsten.Hilbert@xxxxxxx
In-reply-to: <DBAP191MB12892D84093ECBB2CCF8D111B08E9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>
Ma_x_il-followup-to: d
Re_x_turn-receipt-to: Karsten.Hilbert@xxxxxxx
References: <DBAP191MB1289AC6BB681A44166256884B08F9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM> <1156239.1658245261@sss.pgh.pa.us> <DBAP191MB12893B2B95B14B2EC2482ED8B08F9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM> <3dfcd7c4-e133-59f7-f959-0df510682488@gmx.net> <DBAP191MB12892D84093ECBB2CCF8D111B08E9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM>

Am Wed, Jul 20, 2022 at 09:15:29AM +0000 schrieb Sebastien Flaesch:

> Thomas, we already have a similar solution.
> The idea is to use the native PostgreSQL SERIAL type.

Which does not guarantuee gaplessness.

Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence
  - From: Sebastien Flaesch
- Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence
  - From: Tom Lane
- Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence
  - From: Sebastien Flaesch
- Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence
  - From: Thomas Kellerer
- Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence
  - From: Sebastien Flaesch

Prev by Date: operator does not exist: text = bytea
Next by Date: Re: operator does not exist: text = bytea
Previous by thread: Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence
Next by thread: Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]