PGSQL bug - "Column ??? is an identity column defined as GENERATED ALWAYS.",
| От | Petr Hybler | 
|---|---|
| Тема | PGSQL bug - "Column ??? is an identity column defined as GENERATED ALWAYS.", | 
| Дата | |
| Msg-id | CAEMmGb5BN_iRabOKO1_G6LkecxqLHrwFQ=cuN1bJC4HmUsjjLw@mail.gmail.com обсуждение исходный текст | 
| Ответы | Re: PGSQL bug - "Column ??? is an identity column defined as GENERATED ALWAYS.", | 
| Список | pgsql-bugs | 
Hello, I would love to report a bug for the version: 
PostgreSQL 11.13 (Debian 11.13-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
		
	PostgreSQL 11.13 (Debian 11.13-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
After the update, I cannot execute batch inserts. See the example below:
The table structure is as follows:
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)
);
INSERT INTO sample_table (id, name, description)
VALUES (DEFAULT, 'John Doe', 'Test description');
INSERT INTO sample_table (id, name, description)
VALUES (DEFAULT, 'John Doe', 'Test description')
, (DEFAULT, 'Jane Eod', 'Not working');
INSERT INTO sample_table (name, description)
VALUES ('John Doe', 'Test description')
, ('Jane Eod', 'Not working');
P.
В списке pgsql-bugs по дате отправления: