Re: Postgres 12 - Generated Columns - Backup/Restore

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