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
