Re: PGSQL bug - "Column ??? is an identity column defined as GENERATED ALWAYS.",

From: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>
To: Petr Hybler <petr(dot)hybler(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: PGSQL bug - "Column ??? is an identity column defined as GENERATED ALWAYS.",
Date: 2021-08-18 19:27:18
Message-ID: 949dd35d-596e-efce-c5fb-bfef19b74d3b@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 18.08.21 17:06, Petr Hybler wrote:
> |CREATE TABLE sample_table ( id int8 NOT NULL GENERATED ALWAYS AS
> IDENTITY, name varchar(255) NOT NULL, description text NOT NULL,
> CONSTRAINT sample_table_pk PRIMARY KEY (id) );|
>
> When I try to insert a single value, it works OK:
>
> |INSERT INTO sample_table (id, name, description) VALUES (DEFAULT, 'John
> Doe', 'Test description');|
>
> However, when inserting multiple values, it fails:
>
> |INSERT INTO sample_table (id, name, description) VALUES (DEFAULT, 'John
> Doe', 'Test description') , (DEFAULT, 'Jane Eod', 'Not working');|

This has been fixed in PostgreSQL 14.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2021-08-18 21:15:37 PGSQL bug - "Column ??? is an identity column defined as GENERATED ALWAYS.",
Previous Message Daniel Gustafsson 2021-08-18 18:53:00 Re: BUG #17148: About --no-strict-names option and --quiet option of pg_amcheck command