Postgres Pro
Downloads
Home   >   mailing lists

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

From Karsten Hilbert
Subject Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence
Date
Msg-id YtfL5QFRNjFBUegM@hermes.hilbert.loc
Whole thread Raw
In response to Re: Concurrent INSERT statements with RETURNING clause resetting SERIAL sequence  (Sebastien Flaesch <sebastien.flaesch@4js.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Karthik K L V
Date:
Subject: operator does not exist: text = bytea
Next
From: Karthik K L V
Date:
Subject: Re: operator does not exist: text = bytea