Re: additional question about postgresql 10 's new identity column

From: john snow <ofbizfanster(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: additional question about postgresql 10 's new identity column
Date: 2017-12-16 04:26:38
Message-ID: CAE67tvW+3FbRqM4D362XpSbTNAM7Yv79Vi9SMrKOsv8gC2+v0Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

thanks!

On Sat, Dec 16, 2017 at 11:27 AM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Friday, December 15, 2017, john snow <ofbizfanster(at)gmail(dot)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.
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Garry Chen 2017-12-18 16:43:38 Postgresql 10 range partition
Previous Message David G. Johnston 2017-12-16 03:27:11 Re: additional question about postgresql 10 's new identity column