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

  1. pg_dump: Fix dump of generated columns in partitions