Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18067: Droping function that was used to generate column drops the column, even after `DROP EXPRESSION` - Mailing list pgsql-bugs

From Euler Taveira
Subject Re: BUG #18067: Droping function that was used to generate column drops the column, even after `DROP EXPRESSION`
Date
Msg-id 802a85e5-d8ad-4fd8-a395-96565b76a972@app.fastmail.com
Whole thread Raw
In response to BUG #18067: Droping function that was used to generate column drops the column, even after `DROP EXPRESSION`  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view
On Tue, Aug 22, 2023, at 3:57 PM, PG Bug reporting form wrote:
    Hello dear postgres community, I think I stumbled upon a bug involving
generated columns dependencies 
       persisting after the column is not generated anymore.
    This convenient scripts allows to reproduce easily


It was already reported [1] and fixed. Unfortunately, as the commit message [2]
says, the fix cannot be included in version 14 or earlier because it requires
catalog changes. Hence, this fix was included in version 15.




--
Euler Taveira
EDB   https://www.enterprisedb.com/

pgsql-bugs by date:

Previous
From: kaijian xu
Date:
Subject: Re: BUG #18065: An error occurred when attempting to add a column of type "vector" to a table named "vector".
Next
From: PG Bug reporting form
Date:
Subject: BUG #18068: Insufficient permission unless SUPERUSER