[DOCS] Mention new `GENERATED … AS IDENTITY` feature in the `Serial Types` page ?

Поиск
Список
Период
Сортировка
От Basil Bourque
Тема [DOCS] Mention new `GENERATED … AS IDENTITY` feature in the `Serial Types` page ?
Дата
Msg-id 7637CE20-AA33-48C4-AEBA-A0F591F87235@pobox.com
обсуждение исходный текст
Ответы Re: [DOCS] Mention new `GENERATED … AS IDENTITY` feature in the `Serial Types` page ?  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-docs
I suggest adding a mention of `GENERATED … AS IDENTITY` as a replacement for `SERIAL` in the “Serial Types” section
8.1.4of the “Data Types” page. 

https://www.postgresql.org/docs/devel/static/datatype-numeric.html#datatype-serial

Postgres 10 sports a new `GENERATED … AS IDENTITY` for an identity column to effectively replace the `SERIAL`
pseudo-type.

See “PostgreSQL 10 identity columns explained” post for a discussion of the various issues that plague `SERIAL` but not
identitycolumns. 

https://blog.2ndquadrant.com/postgresql-10-identity-columns/

Seems a shame to let the naïve reader continue using `SERIAL` without knowing about identity column feature.

—Basil Bourque

В списке pgsql-docs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [DOCS] No, that's backwards.
Следующее
От: Conor McNally
Дата:
Сообщение: [DOCS] Canonical url for latest document set?