pg_restore - generated column - not populating
Santosh Udupi <email@hitha.net>
From: Santosh Udupi <email@hitha.net>
To: pgsql-general@lists.postgresql.org
Date: 2021-02-23T01:08:17Z
Lists: pgsql-bugs, pgsql-general
Hi all, My database has tables with generated columns. I altered a table and added a generated column as below: alter table billing add primary_bill_to_id int GENERATED ALWAYS as ((info->>'vp')::int) stored Now, when I do the pg_dump and pg_restore, this column does not get populated. It remains null "Info" is the jsonb column in the table and info->>'vp' has values in multiple rows but still generated column "primary_bill_to_id" is null after the restore I am using postgres version 13 Can you tell me what am I missing? Thank you for your help. Santosh
Commits
-
pg_dump: Fix dump of generated columns in partitions
- bdaa0d2d7269 12.7 landed
- a6a3a274abd1 13.3 landed
- feb270d1005f 14.0 landed