Horton

Re: pg_dump insert column GENERATED

Дмитрий Иванов <firstdismay@gmail.com>

View thread View on postgr.es
From: Дмитрий Иванов <firstdismay@gmail.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Date: 2021-11-22T11:32:55Z
Lists: pgsql-general 
Got it.

>
> >You are going need to provide more information about the above:
> >1) Define regular results.
> >2) The query used.
> >3) The outcome vs what you expected.
>
> I will continue to experiment. The question is which option is better
(this would reduce the number of options):
pd_dump is the source server;
pg_restore - receiver server;
or
pd_dump - receiver server;
pg_restore - server-receiver;

Commits

  1. Fix pg_dump --inserts mode for generated columns with dropped columns.