pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18346: pg restore issue with generated cloumn in Postgres v13.14
2+ messages / 2 participants
[nested] [flat]
* BUG #18346: pg restore issue with generated cloumn in Postgres v13.14
@ 2024-02-16 06:15 PG Bug reporting form <noreply@postgresql.org>
2024-02-16 11:20 ` Re: BUG #18346: pg restore issue with generated cloumn in Postgres v13.14 David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2024-02-16 06:15 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: yudara@respax.com
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 ?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #18346: pg restore issue with generated cloumn in Postgres v13.14
2024-02-16 06:15 BUG #18346: pg restore issue with generated cloumn in Postgres v13.14 PG Bug reporting form <noreply@postgresql.org>
@ 2024-02-16 11:20 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2024-02-16 11:20 UTC (permalink / raw)
To: yudara@respax.com <yudara@respax.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
On Thursday, February 15, 2024, PG Bug reporting form <
noreply@postgresql.org> wrote:
> 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:
>
> This
> generated column has a dependecy with another two tables which creates
> after
> this table according the SQL command order in the dump file.
>
These dependencies are not allowed. Change your generated expression to a
trigger.
David J.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-02-16 11:20 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-02-16 06:15 BUG #18346: pg restore issue with generated cloumn in Postgres v13.14 PG Bug reporting form <noreply@postgresql.org>
2024-02-16 11:20 ` David G. Johnston <david.g.johnston@gmail.com>
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