| From: | Santosh Udupi <email(at)hitha(dot)net> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | pg_restore - generated column - not populating |
| Date: | 2021-02-23 01:08:17 |
| Message-ID: | CACLRvHZ4a-+SM_159+tcrHdEqxFrG=W4gwTRnwf7Oj0UNj5R2A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2021-02-23 01:16:48 | Re: pg_restore - generated column - not populating |
| Previous Message | PG Bug reporting form | 2021-02-22 21:20:23 | BUG #16887: Group by is faster than distinct |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2021-02-23 01:16:48 | Re: pg_restore - generated column - not populating |
| Previous Message | Ron | 2021-02-22 23:45:06 | Re: Simple IN vs IN values performace |