Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qYtVM-0033LP-KU for pgsql-bugs@arkaria.postgresql.org; Wed, 23 Aug 2023 19:27:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qYtVL-00Fyti-Cu for pgsql-bugs@arkaria.postgresql.org; Wed, 23 Aug 2023 19:26:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qYtVL-00FytO-3q for pgsql-bugs@lists.postgresql.org; Wed, 23 Aug 2023 19:26:58 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qYtVH-000d8A-Rd for pgsql-bugs@lists.postgresql.org; Wed, 23 Aug 2023 19:26:58 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id 221A25C0045; Wed, 23 Aug 2023 15:26:54 -0400 (EDT) Received: from imap49 ([10.202.2.99]) by compute6.internal (MEProxy); Wed, 23 Aug 2023 15:26:54 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eulerto.com; h= cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm2; t=1692818814; x=1692905214; bh=pO PKWj1SN/2RjClH5Dz7tskp0VJMnGXhYWjTejznyz8=; b=Zs+P+yk+gNqdtG4mcY LxwUQMcPZ2d6ipcGhAreE3vnhOtTEuINXwRw1JY+5/CD77UMPvl/COgHgZtxXejf GWzc5bEaPhOzXWTP+UH0+OkT8uqY6lojXWsemh5U3RQbAhOd7bd6ClTlXLJk16/K CPpFbqsC/d316tvG+vKOwCf4z9JCZwHZGP9GEk0BWle0umuVfIgNQb6NamgP8Rel KbTOZ2qXsYki+Ydbaa0jXgPtRqFzspns7tEif04Vew8rZVve+lT+nuAFMYsqld+q ngDubAYk7Om9DnFVG8B9s+1ejYqM0rVwdsMkHj5JAyrIubxl9yRp+XjMFjDeQ7hd QArg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; t=1692818814; x=1692905214; bh=pOPKWj1SN/2Rj ClH5Dz7tskp0VJMnGXhYWjTejznyz8=; b=QmltNR/9gpOWBGaWYmn5JJ3GnUkyB 7yj13zUuJTIkdHzmmIdicfBDT9oXivv7Hxtyi8bpxJFiX/pFgx1xtxOc2aOGU8oS ZRdfhfToPriAnjPx9rqc7UW4aRqp5BpbvxuCsM87cyDuHKlzK1d2QvCSEW0yOhvQ EKfAazC4hL9kGrjpGEu7NUOs5EbyLzraE4lwHHIAQIN9Cp5jIFHOBgbWnqL2ZQ1j HikB1K9HjCrhKMdTesfOwG/hk9zfIOK6PryxeZxyIS88jVoaXVFIRRYqQm0As2Og 4wuRTmYHvc5W/KZi7/IrugNdewtFePt36cQrdsA8oRl0mGtpoP4hiXSQw== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedruddvgedgudefiecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecunecujfgurhepofgfggfkjghffffhvffutgesrg dtreerreertdenucfhrhhomhepfdfguhhlvghrucfvrghvvghirhgrfdcuoegvuhhlvghr segvuhhlvghrthhordgtohhmqeenucggtffrrghtthgvrhhnpedtjeffieeuieeggeehie eutdevleetteejiedtgfehheefueekvefftedujefhffenucffohhmrghinhepphhoshht ghhrvghsqhhlrdhorhhgpdgvnhhtvghrphhrihhsvggusgdrtghomhenucevlhhushhtvg hrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegvuhhlvghrsegvuhhlvghr thhordgtohhm X-ME-Proxy: Feedback-ID: i0c21471d:Fastmail Received: by mailuser.nyi.internal (Postfix, from userid 501) id B1BF015A0091; Wed, 23 Aug 2023 15:26:53 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.9.0-alpha0-647-g545049cfe6-fm-20230814.001-g545049cf Mime-Version: 1.0 Message-Id: <802a85e5-d8ad-4fd8-a395-96565b76a972@app.fastmail.com> In-Reply-To: <18067-7a71abe62f8c64ca@postgresql.org> References: <18067-7a71abe62f8c64ca@postgresql.org> Date: Wed, 23 Aug 2023 16:26:19 -0300 From: "Euler Taveira" To: 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` Content-Type: multipart/alternative; boundary=4545be84c9a34cb696d9f4eb7ff964af List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --4545be84c9a34cb696d9f4eb7ff964af Content-Type: text/plain 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=cb02fcb4c95bae08adaca1202c2081cfc81a28b5 -- Euler Taveira EDB https://www.enterprisedb.com/ --4545be84c9a34cb696d9f4eb7ff964af Content-Type: text/html Content-Transfer-Encoding: quoted-printable
On Tue, Aug 22,= 2023, at 3:57 PM, PG Bug reporting form wrote:
    Hello dear postg= res community, I think I stumbled upon a bug involving
gen= erated columns dependencies 
    =    persisting after the column is not generated anymore.
    This convenient scripts allows to reproduce = easily


It was a= lready reported [1] and fixed. Unfortunately, as the commit message [2]<= br>
says, the fix cannot be included in version 14 or earlier = because it requires
catalog changes. Hence, this fix was i= ncluded in version 15.


[1] <= a href=3D"https://www.postgresql.org/message-id/17439-7df4421197e928f0%4= 0postgresql.org">https://www.postgresql.org/message-id/17439-7df4421197e= 928f0%40postgresql.org

--4545be84c9a34cb696d9f4eb7ff964af--