Re: Insert/Dump/Restore table with generated columns - Mailing list pgsql-general

zickzack@quantentunnel.de writes:
> After you're answer I did a few investigations. If I insert data with a single insert, everything is working like
expected
> INSERT INTO public.ab VALUES (1, DEFAULT);
> this changes if I do multiple inserts in one statement:
> INSERT INTO public.ab VALUES (1, DEFAULT), (2, DEFAULT);
> ERROR:  cannot insert into column "b"
> DETAIL:  Column "b" is a generated column.

> Is this a bug or a feature?

It's a deficiency :-(.  It's fixed for v14 but the fix seemed too invasive
to back-patch.

https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=17958972f

            regards, tom lane