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

From: Basil Bourque <basil(dot)bourque(at)pobox(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: Mention new `GENERATED … AS IDENTITY` feature in the `Serial Types` page ?
Date: 2017-07-10 20:40:24
Message-ID: 7637CE20-AA33-48C4-AEBA-A0F591F87235@pobox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

I suggest adding a mention of `GENERATED … AS IDENTITY` as a replacement for `SERIAL` in the “Serial Types” section 8.1.4 of 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 identity columns.

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Conor McNally 2017-07-12 21:04:09 Canonical url for latest document set?
Previous Message Tom Lane 2017-07-09 16:52:02 Re: No, that's backwards.