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

Rails test framework insert fixtures records this way, and there is currently no way to tell Rails to ignore these columns for insertion (it should obviously). In my case, this breaks all my test suite. AFAIK this is the same for other frameworks or batch records tools.

Colin Darie

Sent with ProtonMail Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
Le lundi 18 mai 2020 16:57, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> a écrit :

> 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