Re: pg_dump insert column GENERATED
Дмитрий Иванов <firstdismay@gmail.com>
From: Дмитрий Иванов <firstdismay@gmail.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Date: 2021-11-21T15:23:12Z
Lists: pgsql-general
Yes and yes. I don't get regular results in my experiments. I filled in some of the tables this morning, but now I can't do it again. > INSERT INTO bpd.plan_calendar (create in version 12) > OK I can't do it again. >If I am following the bpg.object table was originally created in >Postgres 10, correct? Yes bpd.plan_calendar was created in the Postgres 12 instance of the database with GENERATED ALWAYS AS, correct? Yes >Postgres 10 did not have GENERATED ALWAYS AS, that appeared in Postgres 12. >So did you do an ALTER TABLE ... GENERATED ALWAYS AS on bpg.object in >the Postgres 12 version of the database? I think you're right, I added later. >Means was the instance the standby in a replication setup that was then >moved up(promoted) to the primary. wal_level = replica # minimal, replica, or logical Never been in a replication relationship. Are the below from the bpd.sql file? Yes Why does pg_dump insert data into the calculated columns? I entered the data manually via export/import, excluding the problematic field because its value will be calculated when inserted. > >
Commits
-
Fix pg_dump --inserts mode for generated columns with dropped columns.
- aedc4600d84d 14.2 landed
- 6fc8b145e743 13.6 landed
- 1e7f588ad625 12.10 landed
- 0b126c6a4b00 15.0 landed