Re: BUG #18097: Immutable expression not allowed in generated at - Mailing list pgsql-hackers

From Tom Lane
Subject Re: BUG #18097: Immutable expression not allowed in generated at
Date
Msg-id 11596.1727282881@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #18097: Immutable expression not allowed in generated at  (Adrien Nayrat <adrien.nayrat@anayrat.info>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Adrien Nayrat
Date:
Subject: Re: BUG #18097: Immutable expression not allowed in generated at
Next
From: "Daniel Westermann (DWE)"
Date:
Subject: src/backend/optimizer/util/plancat.c -> Is this correct English