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

Поиск

Список

Период

Сортировка

От	David G. Johnston
Тема	Re: additional question about postgresql 10 's new identity column
Дата	16 декабря 2017 г. 06:27:11
Msg-id	CAKFQuwacFo5J+5u7FfLEdAxfW+10jrnZm2n_PLdNpKS=Oesrcg@mail.gmail.com обсуждение исходный текст
Ответ на	additional question about postgresql 10 's new identity column (john snow <ofbizfanster@gmail.com>)
Ответы	Re: additional question about postgresql 10 's new identity column
Список	pgsql-novice

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 по дате отправления: