Postgres Pro
Downloads
Home   >   mailing lists

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

From john snow
Subject Re: additional question about postgresql 10 's new identity column
Date
Msg-id CAE67tvW+3FbRqM4D362XpSbTNAM7Yv79Vi9SMrKOsv8gC2+v0Q@mail.gmail.com
Whole thread Raw
In response to Re: additional question about postgresql 10 's new identity column  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-novice
Tree view
thanks!

On Sat, Dec 16, 2017 at 11:27 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
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: "David G. Johnston"
Date:
Subject: Re: additional question about postgresql 10 's new identity column
Next
From: Garry Chen
Date:
Subject: Postgresql 10 range partition