Re: SQL:2011 Application Time Update & Delete

On Fri, 20 Feb 2026 at 22:16, Paul A Jungwirth
<pj(at)illuminatedcomputing(dot)com> wrote:
>
> On Fri, Feb 13, 2026 at 12:00 PM Paul A Jungwirth
> <pj(at)illuminatedcomputing(dot)com> wrote:
> >
> > Here is another round to fix a few rebase conflicts.
>
> I realized we didn't have any tests for v18's new feature to say
> `UPDATE ... RETURNING OLD.foo, NEW.foo`. These patches add a small
> test for `RETURNING OLD.valid_at, NEW.valid_at` when you say `UPDATE
> FOR PORTION OF valid_at`. This seems worth testing since that column
> gets set in an automatic way, not via the normal SET syntax. No fixes
> were needed.
>
> I also corrected the commit message, which still referred to the
> without_overlaps function that we renamed to
> {range,multirange}_minus_multi.
>
> As far as I know nothing else here is waiting on me, but please
> correct me if I've overlooked something.
>
> Rebased to 18bcdb75d1.
>
> Yours,
>
> --
> Paul ~{:-)
> pj(at)illuminatedcomputing(dot)com

Hi!
v67-0001 looks good to me.

When applying first two of patches from v67 series, my initdb fails:

```
reshke(at)yezzey-cbdb-bench:~/cpg$ ./bin/bin/initdb -D ./db
The files belonging to this database system will be owned by user "reshke".
This user must also own the server process.

The database cluster will be initialized with locale "C.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are enabled.

creating directory db ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default "max_connections" ... 100
selecting default "shared_buffers" ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... 2026-03-10 12:21:05.842
UTC [2995664] WARNING: unrecognized node type: 155
2026-03-10 12:21:05.842 UTC [2995664] FATAL: unrecognized node type: 155
2026-03-10 12:21:05.842 UTC [2995664] STATEMENT: REVOKE ALL ON
pg_authid FROM public;

child process exited with exit code 1
initdb: removing data directory "db"
```

without v67-0002 initdb runs ok.

Also, after v67-0002 my createdb fails:

```
reshke(at)yezzey-cbdb-bench:~/cpg$ ./bin/bin/createdb
createdb: error: query failed: ERROR: syntax error at or near "("
LINE 1: SELECT pg_catalog.set_config('search_path', '', false);
^
createdb: detail: Query was: SELECT
pg_catalog.set_config('search_path', '', false);
```

Simple queries also fails:
```
postgres=# select now();
WARNING: unrecognized node type: 144
ERROR: unrecognized node type: 76
```

--
Best regards,
Kirill Reshke