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

From: Aleksander Alekseev <aleksander(at)timescale(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, James Keener <jim(at)jimkeener(dot)com>
Subject: Re: BUG #18097: Immutable expression not allowed in generated at
Date: 2023-11-15 11:44:09
Message-ID: CAJ7c6TN3myMtC4_r+68=a_z60NkBipowWyX76e1j_7Vp05TPnA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hi,

> > Oh no! We encountered one of the most difficult problems in computer
> > science [1].
>
> Indeed :-(. Looking at it again this morning, I'm thinking of
> using "contain_mutable_functions_after_planning" --- what do you
> think of that?

It's better but creates an impression that the actual planning will be
involved. According to the comments for expression_planner():

```
* Currently, we disallow sublinks in standalone expressions, so there's no
* real "planning" involved here. (That might not always be true though.)
```

I'm not very well familiar with the part of code responsible for
planning, but I find this inconsistency confusing.

Since the code is written for people to be read and is read more often
than written personally I believe that longer and more descriptive
names are better. Something like
contain_mutable_functions_after_planner_transformations(). This being
said, in practice one should read the comments to learn about corner
cases, pre- and postconditions anyway, so maybe it's not that a big
deal. I think of contain_mutable_functions_after_transformations() as
a good compromise between the length and descriptiveness.

--
Best regards,
Aleksander Alekseev

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Christoph Berg 2023-11-15 11:46:28 Re: BUG #18199: 'Release' file not available in apt.postgresql.org/pub/repos/apt bionic-pgdg
Previous Message PG Bug reporting form 2023-11-15 11:02:04 BUG #18199: 'Release' file not available in apt.postgresql.org/pub/repos/apt bionic-pgdg

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2023-11-15 11:44:36 Re: Allow tests to pass in OpenSSL FIPS mode
Previous Message Peter Eisentraut 2023-11-15 11:39:30 Re: ALTER COLUMN ... SET EXPRESSION to alter stored generated column's expression