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.