[DOCS] Mention new `GENERATED … AS IDENTITY` feature in the `Serial Types` page ? - Mailing list pgsql-docs

From Basil Bourque
Subject [DOCS] Mention new `GENERATED … AS IDENTITY` feature in the `Serial Types` page ?
Date
Msg-id 7637CE20-AA33-48C4-AEBA-A0F591F87235@pobox.com
Whole thread Raw
Responses Re: [DOCS] Mention new `GENERATED … AS IDENTITY` feature in the `Serial Types` page ?  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [DOCS] No, that's backwards.
Next
From: Conor McNally
Date:
Subject: [DOCS] Canonical url for latest document set?