Postgres Pro
Downloads
Home   >   mailing lists

Re: additional question about postgresql 10 's new identity column - Mailing list pgsql-novice

From David G. Johnston
Subject Re: additional question about postgresql 10 's new identity column
Date
Msg-id CAKFQuwacFo5J+5u7FfLEdAxfW+10jrnZm2n_PLdNpKS=Oesrcg@mail.gmail.com
Whole thread Raw
In response to additional question about postgresql 10 's new identity column  (john snow <ofbizfanster@gmail.com>)
Responses Re: additional question about postgresql 10 's new identity column  (john snow <ofbizfanster@gmail.com>)
List pgsql-novice
Tree view
On Friday, December 15, 2017, john snow <ofbizfanster@gmail.com> wrote:
 
anything we can do or configure so that failed inserts wont advance the nextval for the primary key?

No. PostgreSQL favors concurrency in this.  If you want to go gap-less you will need to write it up yourself.

David J. 

pgsql-novice by date:

Previous
From: john snow
Date:
Subject: additional question about postgresql 10 's new identity column
Next
From: john snow
Date:
Subject: Re: additional question about postgresql 10 's new identity column