pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedMention new `GENERATED … AS IDENTITY` feature in the `Serial Types` page ?
2+ messages / 2 participants
[nested] [flat]
* Mention new `GENERATED … AS IDENTITY` feature in the `Serial Types` page ?
@ 2017-07-10 20:40 Basil Bourque <basil.bourque@pobox.com>
2017-08-22 23:59 ` Re: Mention new `GENERATED … AS IDENTITY` feature in the `Serial Types` page ? Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 1 reply; 2+ messages in thread
From: Basil Bourque @ 2017-07-10 20:40 UTC (permalink / raw)
To: 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
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Mention new `GENERATED … AS IDENTITY` feature in the `Serial Types` page ?
2017-07-10 20:40 Mention new `GENERATED … AS IDENTITY` feature in the `Serial Types` page ? Basil Bourque <basil.bourque@pobox.com>
@ 2017-08-22 23:59 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2017-08-22 23:59 UTC (permalink / raw)
To: Basil Bourque <basil.bourque@pobox.com>; pgsql-docs
On 7/10/17 16:40, Basil Bourque wrote:
> 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.
Done, thanks for the tip!
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-08-22 23:59 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-07-10 20:40 Mention new `GENERATED … AS IDENTITY` feature in the `Serial Types` page ? Basil Bourque <basil.bourque@pobox.com>
2017-08-22 23:59 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox