Postgres Pro
Downloads
Home   >   mailing lists

Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence - Mailing list pgsql-general

From Sebastien Flaesch
Subject Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence
Date
Msg-id DBAP191MB12893B2B95B14B2EC2482ED8B08F9@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence  (Francisco Olarte <folarte@peoplecall.com>)
Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence  (Thomas Kellerer <shammat@gmx.net>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Benedict Holland
Date:
Subject: Re: restore question
Next
From: Adrian Klaver
Date:
Subject: Re: restore question