| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | onavratil(at)monetplus(dot)cz |
| Subject: | BUG #18543: Mistake in docs example |
| Date: | 2024-07-17 12:53:39 |
| Message-ID: | 18543-93c721689f9928e8@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 18543
Logged by: Ondřej Navrátil
Email address: onavratil(at)monetplus(dot)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 ) ] |
...
```
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aleksander Alekseev | 2024-07-17 13:58:26 | Re: libpq: unexpected return code from PQexecParams with a DO INSTEAD rule present |
| Previous Message | Tom Lane | 2024-07-16 12:45:15 | Re: BUG #18542: Order by expression, that contains column from projection isn't working |