From: Euler Taveira <euler@eulerto.com>
To: remi.cura@gmail.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18067: Droping function that was used to generate column drops the column, even after `DROP EXPRESSION`
Date: Wed, 23 Aug 2023 16:26:19 -0300
Message-ID: <802a85e5-d8ad-4fd8-a395-96565b76a972@app.fastmail.com> (raw)
In-Reply-To: <18067-7a71abe62f8c64ca@postgresql.org>
References: <18067-7a71abe62f8c64ca@postgresql.org>
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.
[1] https://www.postgresql.org/message-id/17439-7df4421197e928f0%40postgresql.org
[2] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=cb02fcb4c95bae08adaca1202c2081cfc81a2...
--
Euler Taveira
EDB https://www.enterprisedb.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: euler@eulerto.com, remi.cura@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18067: Droping function that was used to generate column drops the column, even after `DROP EXPRESSION`
In-Reply-To: <802a85e5-d8ad-4fd8-a395-96565b76a972@app.fastmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox