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

Insert/Dump/Restore table with generated columns

2021-07-01 Thread zickzack
Hi, 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 case of the error no insert takes place