zickzack@xxxxxxxxxxxxxxxx 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
