Re: Insert/Dump/Restore table with generated columns

2021-07-08 Thread Tom Lane
zickz...@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,

Re: Re: Insert/Dump/Restore table with generated columns

2021-07-08 Thread zickzack
Hi David, thanks for you're quick answer. I'am using postgres 12 and also tested with 13. Both inside the official (debian based) docker hub hosted container. After you're answer I did a few investigations. If I insert data with a single insert, everything is working like expected INSERT INTO

Re: Insert/Dump/Restore table with generated columns

2021-07-01 Thread David Rowley
On Thu, 1 Jul 2021 at 22:06, wrote: > I have several tables with generated columns. If I restore the plain dumped > data (insert statements from pg_dump) I'll get the error message "Column xyz > is a generated column.". The exception is understandably, no question (and is > well documented). In