From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: yudara@respax.com
Subject: BUG #18346: pg restore issue with generated cloumn in Postgres v13.14
Date: Fri, 16 Feb 2024 06:15:54 +0000
Message-ID: <18346-e72442085a58af97@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18346
Logged by: YG
Email address: yudara@respax.com
PostgreSQL version: 13.14
Operating system: Ubuntu-20.04.2
Description:
We are having issue with restore some DBs to postgres v13.14 when there are
tables with "Generated Column (stored)".
Steps we did as follows
Back up a DB from pg_dump v13.14 from DB server(v13.14)
Restore using psql to same or another DB server(v13.14) . There is error
coming when creating a table which has a Generated Column (stored) saying
that relation does not exist(checking the existance of another table). This
generated column has a dependecy with another two tables which creates after
this table according the SQL command order in the dump file.
We do not get this error when restoring to the postgres version 13.12 ,
13.11 or below in the same major version.
So we suspect that it is something to do with the lastet postgres version
13.14. Can someone please assist ?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, yudara@respax.com
Subject: Re: BUG #18346: pg restore issue with generated cloumn in Postgres v13.14
In-Reply-To: <18346-e72442085a58af97@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox