MIME-Version: 1.0
References: <ec498c3d-5f2b-48ec-b989-5561c8aa2024@illuminatedcomputing.com>
 <CA+renyW7ZB_k9AgmSFJU2EegL9r1k1sgWo4-9tGGkgwxNqe6kw@mail.gmail.com>
 <CA+renyUodzxAvMnpa_LTvo+Ru1ZKH+Su8KaPvD4iMtguFKzq4g@mail.gmail.com>
 <1ace7bc1-9dd4-42c9-a473-517cef37cce9@eisentraut.org>
 <CA+renyU-iz_zvM0gGP=dvBPVrz=Jj3qdCjtAh5nLZRhb49xMFw@mail.gmail.com>
 <6F8D7105-BD1C-432D-84F3-BC688C0C8EDC@gmail.com>
 <9B820A52-D2F6-465D-B258-6FE8EBA59FAE@gmail.com>
 <CA+renyXchHgpMbYX-cR8fuNnnpf_+FJ6PkHoXoa2AgzRnz4vxQ@mail.gmail.com>
 <53a13f97-340f-4d04-9dcc-77ca3ffb6a6a@eisentraut.org>
 <CA+renyXH3AF6JVzZGVcT5mAo=0QncB-MpWJeqb2JG66sgyq09g@mail.gmail.com>
 <85ac7f0e-d95f-4377-ade0-8941fd328012@eisentraut.org>
 <CA+renyUazgR-hB_6RY60n23L0y-n_h9G1AappZmPENO0k5pL1g@mail.gmail.com>
 <7d63ddfa-c735-4dfe-8c7a-4f1e2a621058@eisentraut.org>
 <CA+renyVXg5pV84wQnGQuK8-=qoKw3BiBgQzesxM_LkcxxWmYjA@mail.gmail.com>
 <e59d218a-ae49-490f-ae6f-86c12f35d3c3@eisentraut.org>
 <CA+renyWKOj5=rMmQmJcbybu-Vdomxdp=eJ93kp76AgmQKYdfiQ@mail.gmail.com>
 <4606deaa-7d65-4f22-8a78-356c3180be9d@eisentraut.org>
 <CA+renyUhuXB2nTVCMREXew9E4DZOnFxQNjME5bcw91+k72Bosg@mail.gmail.com>
 <CA+renyWUCSyTMn3s03kviEN-oaVrJP-QkDQCLNfaY=MHV5QEiQ@mail.gmail.com>
 <CA+renyV4tWU2d=n9_v=XNPHbZfNqqLokzd-Xt78M-zLd+46ubA@mail.gmail.com>
 <CALdSSPjKLuqbLen2HSFs1Uef-hetVwZqqdZKPd45gfsVvHRhZA@mail.gmail.com>
In-Reply-To: 
 <CALdSSPjKLuqbLen2HSFs1Uef-hetVwZqqdZKPd45gfsVvHRhZA@mail.gmail.com>
From: Paul A Jungwirth <pj@illuminatedcomputing.com>
Date: Tue, 10 Mar 2026 09:13:00 -0700
Message-ID: 
 <CA+renyXUy6W4xqS5Mi2e0D_PF1ZVTw5jacd0tAOboyg5e5DNTQ@mail.gmail.com>
Subject: Re: SQL:2011 Application Time Update & Delete
To: Kirill Reshke <reshkekirill@gmail.com>
Cc: Peter Eisentraut <peter@eisentraut.org>, Chao Li <li.evan.chao@gmail.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BrenyXUy6W4xqS5Mi2e0D_PF1ZVTw5jacd0tAOboyg5e5DNTQ%40mail.gmail.com>
Precedence: bulk

On Tue, Mar 10, 2026 at 5:26=E2=80=AFAM Kirill Reshke <reshkekirill@gmail.c=
om> wrote:
> When applying first two of patches from v67 series, my initdb fails:
>
> ```
> reshke@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@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=3D# select now();
> WARNING:  unrecognized node type: 144
> ERROR:  unrecognized node type: 76
> ```

I don't see any of these problems here (after an error-free rebase
onto a198c26ded), and CI passes. Are you sure that was from a clean
build? If so, could you share your configure line?

Thanks,

--=20
Paul              ~{:-)
pj@illuminatedcomputing.com