Horton

Re: pg_restore - generated column - not populating

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Santosh Udupi <email@hitha.net>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, pgsql-general@lists.postgresql.org
Date: 2021-02-23T18:40:11Z
Lists: pgsql-bugs, pgsql-general 
Santosh Udupi <email@hitha.net> writes:
> Both are different versions
> The following works:
> Version: pg_dump (pgAdmin Windows)  version:13.1

> The following does not work: (Does not populate the generated column
> values)
> Version: pg_dump (PostgreSQL v13.2 on Ubuntu 20.04)  version 13.2

Hmm ... well, that would be a regression, but you're going to have
to show us how to reproduce it.  I'm thinking there must be something
odd about the way the table is declared.

			regards, tom lane

Commits

  1. pg_dump: Fix dump of generated columns in partitions