Re: BUG #18464: Replacing a SQL function silently drops the generated columns that use this function

Поиск
Список
Период
Сортировка
От Rémi Cura
Тема Re: BUG #18464: Replacing a SQL function silently drops the generated columns that use this function
Дата
Msg-id CAJvUf_uEW2x6iEeCTW667L_Q153_vjgYgeDQQXgvLS9CNWCe8g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #18464: Replacing a SQL function silently drops the generated columns that use this function  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения
Awesome!
The irony is that I triggered this behavior while solving issues in order to upgrade to PG16 :-)
thank you very much again
Rémi



On Wed, May 15, 2024, 17:56 Tom Lane <tgl@sss.pgh.pa.us> wrote:
Rémi Cura <remi.cura@gmail.com> writes:
> I tried to reproduce, and as you pointed out, updating the function in
> place is not what dropped the columns.
> Instead, I must have dropped and recreated the function, which indeed drops
> the generated columns.
> I still feel this is a very dangerous behavior.

Yeah, we changed this at v15.  See

https://www.postgresql.org/message-id/flat/17439-7df4421197e928f0%40postgresql.org

https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=cb02fcb4c

                        regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #18463: Possible bug in stored procedures with polymorphic OUT parameters
Следующее
От: WU Yan
Дата:
Сообщение: Re: BUG #18466: Wrong row estimate for nested loop