Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18346: pg restore issue with generated cloumn in Postgres v13.14 - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #18346: pg restore issue with generated cloumn in Postgres v13.14
Date
Msg-id CAKFQuwbGTHbhqahhW+3_Ej9aY9PKtav-i0XL3Q4pD_+bCAxOSQ@mail.gmail.com
Whole thread Raw
In response to BUG #18346: pg restore issue with generated cloumn in Postgres v13.14  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view
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.

pgsql-bugs by date:

Previous
From: David Rowley
Date:
Subject: Re: UPDATE modifies more rows that it should
Next
From: David Rowley
Date:
Subject: Re: UPDATE modifies more rows that it should