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
Views: Raw Message | Whole Thread | Download mbox
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.

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.

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

—Basil Bourque


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.