Re: BUG #16441: Cannot multi-insert into generated column with DEFAULT value

On 2020-05-15 23:07, PG Bug reporting form wrote:
> 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.

Yes, this has been reported before. This is basically just not
implemented. Is there a reason you need to use this form, or are you
just trying things out?

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services