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: Sebastien Flaesch <sebastien.flaesch@xxxxxxx>
Date: Tue, 19 Jul 2022 16:50:28 +0000
Accept-language: en-US
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <1156239.1658245261@sss.pgh.pa.us>
References: <DBAP191MB1289AC6BB681A44166256884B08F9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM> <1156239.1658245261@sss.pgh.pa.us>
Suggested_attachment_session_id: 9b5ff866-8a31-6ff8-a2eb-60943740aa0d

Tom,

If that's the behavior you want, you can build it out of standard SQL facilities (e.g. update a one-row table).

Can you elaborate please?

Do you mean the code should use an UPDATE on a one-row table to acquire a lock?

Seb

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

Follow-Ups:
- Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence
  - From: Thomas Kellerer
- Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence
  - From: Francisco Olarte

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

Prev by Date: Re: restore question
Next by Date: Re: restore question
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]

Powered by Linux