pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re : Re: BUG #16441: Cannot multi-insert into generated column with DEFAULT value
2+ messages / 2 participants
[nested] [flat]

* Re : Re: BUG #16441: Cannot multi-insert into generated column with DEFAULT value
@ 2020-05-18 15:10 Colin Darie <colin@darie.eu>
  2020-05-20 14:43 ` Re: Re : Re: BUG #16441: Cannot multi-insert into generated column with DEFAULT value Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Colin Darie @ 2020-05-18 15:10 UTC (permalink / raw)
  To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>; +Cc: pgsql-bugs@lists.postgresql.org

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.eisentraut@2ndquadrant.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







^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Re : Re: BUG #16441: Cannot multi-insert into generated column with DEFAULT value
  2020-05-18 15:10 Re : Re: BUG #16441: Cannot multi-insert into generated column with DEFAULT value Colin Darie <colin@darie.eu>
@ 2020-05-20 14:43 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2020-05-20 14:43 UTC (permalink / raw)
  To: Colin Darie <colin@darie.eu>; +Cc: pgsql-bugs@lists.postgresql.org

On 2020-05-18 17:10, Colin Darie wrote:
> 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.

OK, that makes sense.  I'll take another look.

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2020-05-20 14:43 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-05-18 15:10 Re : Re: BUG #16441: Cannot multi-insert into generated column with DEFAULT value Colin Darie <colin@darie.eu>
2020-05-20 14:43 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox