PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16441
PG Version12.3
OSmacos
Opened2020-05-15 21:07:33+00
Reported byColin Darie
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16441
Logged by:          Colin Darie
Email address:      (redacted)
PostgreSQL version: 12.3
Operating system:   macos
Description:        

Multiple inserts of DEFAULT value for generated columns are failing. Single
inserts are OK.


CREATE TABLE squares (num INTEGER NOT NULL, square INTEGER GENERATED ALWAYS
AS (num * num) STORED);


INSERT INTO squares(num, square) VALUES (1, DEFAULT);
=> INSERT 0 1
INSERT INTO squares(num, square) VALUES (2, DEFAULT), (3, DEFAULT);
=> ERROR:  cannot insert into column "square"
=> DETAIL:  Column "square" is a generated column.


Tested with postgresql 12.2 and 12.3 on macos.

Messages

DateAuthorSubject
2020-05-15 21:07:33+00PG Bug reporting formBUG #16441: Cannot multi-insert into generated column with DEFAULT value
2020-05-18 14:57:26+00Peter EisentrautRe: BUG #16441: Cannot multi-insert into generated column with DEFAULT value
2020-05-18 15:10:48+00Colin DarieRe : Re: BUG #16441: Cannot multi-insert into generated column with DEFAULT value
2020-05-20 14:43:25+00Peter EisentrautRe: Re : Re: BUG #16441: Cannot multi-insert into generated column with DEFAULT value