Re: BUG #18097: Immutable expression not allowed in generated at

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: Adrien Nayrat <adrien.nayrat@anayrat.info>

Cc: pgsql-hackers@lists.postgresql.org

Date: 2024-09-25T16:48:01Z

Lists: pgsql-bugs, pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Ensure we preprocess expressions before checking their volatility.
- f07a3039c72b 16.2 landed
- abd1b1325d60 12.18 landed
- 9bd0f74eac19 14.11 landed
- 9057ddbefe7e 15.6 landed
- 743ddafc7124 17.0 landed
- 5c11104c7d20 13.14 landed

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