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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1stVBS-00GvSx-IA
	for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Sep 2024 16:48:11 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1stVBR-00B3Qn-Hl
	for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Sep 2024 16:48:09 +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 <tgl@sss.pgh.pa.us>)
	id 1stVBR-00B3Qf-7X
	for pgsql-hackers@lists.postgresql.org; Wed, 25 Sep 2024 16:48:09 +0000
Received: from sss.pgh.pa.us ([68.162.161.243])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1stVBN-001373-Jp
	for pgsql-hackers@lists.postgresql.org; Wed, 25 Sep 2024 16:48:08 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 48PGm1Jf011597;
	Wed, 25 Sep 2024 12:48:01 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Adrien Nayrat <adrien.nayrat@anayrat.info>
cc: pgsql-hackers@lists.postgresql.org
Subject: Re: BUG #18097: Immutable expression not allowed in generated at
In-reply-to: <0267c3d0-f5f3-42e2-bf07-29ec10dd728e@anayrat.info>
References: <18097-ebb179674f22932f@postgresql.org>
 <CAKFQuwZW=wyr_Nfi8Ww+U-jxdh4tvztvMjT23iv2Ly+Oc0n5eQ@mail.gmail.com>
 <118FF128-C9CA-490C-8E67-65888EE8283F@jimkeener.com>
 <1887197.1694189299@sss.pgh.pa.us> <2250243.1694287087@sss.pgh.pa.us>
 <2275069.1694300202@sss.pgh.pa.us>
 <CAJ7c6TNNG_x8enNdhqmGdg_9A0fNa0LBadecBkuHc-=a7YqaFg@mail.gmail.com>
 <2502479.1699984134@sss.pgh.pa.us>
 <CAJ7c6TN3myMtC4_r+68=a_z60NkBipowWyX76e1j_7Vp05TPnA@mail.gmail.com>
 <2661435.1700061355@sss.pgh.pa.us>
 <CAJ7c6TNX7itd4TCUOmUXWng_C695t9WQsp8bZ_A61PBXvEV0kQ@mail.gmail.com>
 <389130.1700147198@sss.pgh.pa.us>
 <594289a1-922d-497b-939e-20a95a71126d@anayrat.info>
 <3646824.1727275267@sss.pgh.pa.us>
 <0267c3d0-f5f3-42e2-bf07-29ec10dd728e@anayrat.info>
Comments: In-reply-to Adrien Nayrat <adrien.nayrat@anayrat.info>
	message dated "Wed, 25 Sep 2024 18:36:45 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <11595.1727282881.1@sss.pgh.pa.us>
Date: Wed, 25 Sep 2024 12:48:01 -0400
Message-ID: <11596.1727282881@sss.pgh.pa.us>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/11596.1727282881%40sss.pgh.pa.us>
Precedence: bulk

Adrien Nayrat <adrien.nayrat@anayrat.info> writes:
> I see. So I understand we were lucky it worked before the commit added 
> the check of volatility in generated column ?

Pretty much.  There are other cases that could trigger expansion
of such a function before the restore is complete.  It is unfortunate
that this bit you in a minor release, but there are lots of other
ways you could have tripped over the missing dependency unexpectedly.

			regards, tom lane