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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rémi Cura <remi(dot)cura(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18464: Replacing a SQL function silently drops the generated columns that use this function
Date: 2024-05-15 15:56:03
Message-ID: 1786278.1715788563@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?UTF-8?Q?R=C3=A9mi_Cura?= <remi(dot)cura(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2024-05-15 17:28:57 Re: BUG #18463: Possible bug in stored procedures with polymorphic OUT parameters
Previous Message Dmitry Dolgov 2024-05-15 14:35:06 Re: BUG #18463: Possible bug in stored procedures with polymorphic OUT parameters