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: | Raw Message | Whole Thread | 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 |