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
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 |
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 |