Re: BUG #18464: Replacing a SQL function silently drops the generated columns that use this function - Mailing list pgsql-bugs

From Muhammad Waqas
Subject Re: BUG #18464: Replacing a SQL function silently drops the generated columns that use this function
Date
Msg-id CAHYHq4WcbMZnz9hQQgpEn-KCqrQfcz+NQcP3gdD4YSLrogsDmQ@mail.gmail.com
Whole thread Raw
In response to BUG #18464: Replacing a SQL function silently drops the generated columns that use this function  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
When you drop any object with cascade option all associated object will be dropped. That is the normal behavior just and other behavior is not normal

2024년 5월 14일 (화) 오후 8:37, PG Bug reporting form <noreply@postgresql.org>님이 작성:
The following bug has been logged on the website:

Bug reference:      18464
Logged by:          Rémi Cura
Email address:      remi.cura@gmail.com
PostgreSQL version: 14.10
Operating system:   Linux
Description:       

I have a SQL function that I defined myself. Let's call it MyFunction().
I use MyFunction in generated columns of 2 distinct tables.
Whe trying to delete MyFunction, the DB correctly raises an error.
However, when I `CREATE OR REPLACE` this existing function in place, the DB
silently drop all the generated columns depending on this function.
This is not the expected behavior.
I should get either an error, or no columns should be dropped.
if they are dropped, I should get at the very least a warning.

This is pretty major: having columns disappear magically on prod dbs is not
what postgres usually do.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18464: Replacing a SQL function silently drops the generated columns that use this function
Next
From: Laurenz Albe
Date:
Subject: Re: BUG #18362: unaccent rules and Old Greek text