BUG #18543: Mistake in docs example

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 ) ] |
...
```

Responses

Browse pgsql-bugs by date

  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