BUG #18543: Mistake in docs example

Started by PG Bug reporting formalmost 2 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 18543
Logged by: Ondřej Navrátil
Email address: onavratil@monetplus.cz
PostgreSQL version: 16.3
Operating system: windows
Description:

https://www.postgresql.org/docs/17/ddl-identity-columns.html

The second example:

```
CREATE TABLE people (
id bigint GENERATED BY DEFAULT IDENTITY,
...,
);
```

is missing **AS**, correct version:

```
CREATE TABLE people (
id bigint GENERATED BY DEFAULT AS IDENTITY,
...,
);
```

... as per syntax here
https://www.postgresql.org/docs/current/sql-createtable.html
```
...
GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( sequence_options ) ] |
...
```

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PG Bug reporting form (#1)
Re: BUG #18543: Mistake in docs example

PG Bug reporting form <noreply@postgresql.org> writes:

https://www.postgresql.org/docs/17/ddl-identity-columns.html

The second example:

CREATE TABLE people (
id bigint GENERATED BY DEFAULT IDENTITY,

is missing **AS**, correct version:

CREATE TABLE people (
id bigint GENERATED BY DEFAULT AS IDENTITY,

Right you are. Will fix, thanks for spotting that!

regards, tom lane