DomainKey-Signature: a=rsa-sha1; c=nofws; d=pobox.com; h=from
	:content-type:content-transfer-encoding:mime-version:subject
	:message-id:date:to; q=dns; s=sasl; b=Kk+lKhc+63l6rKOzxALoQn76C4
	oPGR64G7wYGb8vbdAgQy/mv4xZ6TZ+ne1vuEEAro/DxUHAdVW2Wxy6YsDtsjhO9q
	doVkv/HHO9OjFXUYrKlX28BqCpajLv6ZYUDr4vB15mMoS9Joom7FxzN5p9SmmY4E
	174zDlbblC5M9YNMk=
From: Basil Bourque <basil.bourque@pobox.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 10.3 \(3273\))
Subject: =?utf-8?Q?Mention_new_=60GENERATED_=E2=80=A6_AS_IDENTITY=60_featu?=
 =?utf-8?Q?re_in_the_=60Serial_Types=60_page_=3F?=
Message-Id: <7637CE20-AA33-48C4-AEBA-A0F591F87235@pobox.com>
Date: Mon, 10 Jul 2017 13:40:24 -0700
To: pgsql-docs@postgresql.org
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

I suggest adding a mention of `GENERATED =E2=80=A6 AS IDENTITY` as a replac=
ement for `SERIAL` in the =E2=80=9CSerial Types=E2=80=9D section 8.1.4 of t=
he =E2=80=9CData Types=E2=80=9D page.

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

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

See =E2=80=9CPostgreSQL 10 identity columns explained=E2=80=9D post for a d=
iscussion of the various issues that plague `SERIAL` but not identity colum=
ns.

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

Seems a shame to let the na=C3=AFve reader continue using `SERIAL` without =
knowing about identity column feature.

=E2=80=94Basil Bourque

--=20
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs