Re: Postgres 12 - Generated Columns - Backup/Restore

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Santosh Udupi <email(at)hitha(dot)net>, pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres 12 - Generated Columns - Backup/Restore
Date: 2021-01-21 12:36:14
Message-ID: 4c014c47efcfe56cd2aa708e592bd29d75bf4adf.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, 2021-01-20 at 17:32 -0800, Santosh Udupi wrote:
> My Postgres 12 database tables have generated columns. I use pg_dump to backup
> the database but when I restore using pg_restore, the generated columns are empty.
> How do I trigger creating the data in the generated columns?

Does the expression that generates the computed column uses an
expression containing a function that is marked IMMUTABLE, but
isn't really?

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Santosh Udupi 2021-01-21 13:51:26 Re: Postgres 12 - Generated Columns - Backup/Restore
Previous Message Tom Lane 2021-01-21 01:35:26 Re: Postgres 12 - Generated Columns - Backup/Restore