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

Поиск
Список
Период
Сортировка
От Euler Taveira
Тема Re: BUG #18067: Droping function that was used to generate column drops the column, even after `DROP EXPRESSION`
Дата
Msg-id 802a85e5-d8ad-4fd8-a395-96565b76a972@app.fastmail.com
обсуждение исходный текст
Ответ на BUG #18067: Droping function that was used to generate column drops the column, even after `DROP EXPRESSION`  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: kaijian xu
Дата:
Сообщение: Re: BUG #18065: An error occurred when attempting to add a column of type "vector" to a table named "vector".
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18068: Insufficient permission unless SUPERUSER