Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.500.181\))
Subject: Re: BUG #19382: Server crash at __nss_database_lookup
From: Andrey Borodin <x4mmm@yandex-team.ru>
In-Reply-To: <CAOVWO5pjr=qTkf0fMFfrhtnweBJihxkm=NhhuNuoBfrTAgP5ew@mail.gmail.com>
Date: Fri, 17 Apr 2026 11:57:15 +0500
Cc: songjinzhou <tsinghualucky912@foxmail.com>,
 dllggyx <dllggyx@outlook.com>,
 pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <674982B4-2824-433D-AFC4-CCBF410D9424@yandex-team.ru>
References: <19382-4c2060ffee72759b@postgresql.org>
 <CAOVWO5rVBKsjG4YwO_PJQu2OBGp8qUdF1jineYY6Lm3zc6-KWQ@mail.gmail.com>
 <CAOVWO5rbwKgHWLYJMvKuvGxW9eFSk7LADk=ZxDEvwA1uTefvAg@mail.gmail.com>
 <CAOVWO5qN8UXdwMnDa+a7aVq=irGSfm2aeYvEc-uV6j4QHZiyrA@mail.gmail.com>
 <CAOVWO5py4zLPYsnGK1EEzHnC4feTSmbsEZn-BiDgY_=J1P6Wmw@mail.gmail.com>
 <CAOVWO5pbgCVx0zgTr1mxZug2hoGwxZOk+-Owvwg0jaQv9JE3Fw@mail.gmail.com>
 <CAOVWO5r19cctAFKbW24jfMKsD-pkyV21w+z7L3pCPxM1CArtjQ@mail.gmail.com>
 <CAOVWO5oSeBouPv0ueVByh+_6EgRCjWh0spSmnF6Cv-TF1twqKg@mail.gmail.com>
 <tencent_04DAF0C76A6A76A8C7B48212F2362C818A09@qq.com>
 <CAOVWO5oH37CETZuxxXw3dhCMOHPMA0xFoJBWTpfJ06OV7sGzTQ@mail.gmail.com>
 <D279BE7A-0E13-450A-8639-25937E94611D@yandex-team.ru>
 <CAOVWO5oRGPd7mA3d85jNYmjLNfeBAca5oDcHTfRFxbAwPLxs5g@mail.gmail.com>
 <D9FAF41E-8082-47AF-B36E-4FB9EAF8378B@yandex-team.ru>
 <CAOVWO5o9YOpCTgg6FfNepCoH_6pFSa7TJ3SEWfJAoBvNOb0OdQ@mail.gmail.com>
 <CC383BAA-1653-427A-975C-D27E2702E1E2@yandex-team.ru>
 <CAOVWO5pjr=qTkf0fMFfrhtnweBJihxkm=NhhuNuoBfrTAgP5ew@mail.gmail.com>
To: surya poondla <suryapoondla4@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/674982B4-2824-433D-AFC4-CCBF410D9424%40yandex-team.ru>
Precedence: bulk


> On 17 Apr 2026, at 04:20, surya poondla <suryapoondla4@gmail.com> =
wrote:
>=20
> I also added a fast-path optimization in =
snapshot_record_composite_types() to avoid repeated type tree walks when =
a record is assigned in a loop =E2=80=94 it skips the snapshot if the =
outermost type's tupDesc_identifier hasn't changed since the last =
snapshot.

Cool, but ISTM that it won=E2=80=99t work for domains.

if (rec->nCompTypes > 0 && rec->compTypeOids[0] =3D=3D rec->rectypeid)

compTypeOids is composite, rectypeid is domain oid.
Can we make this work for domains too?

> Added both new test cases (Cases 5 and 6) to the regression. All 248 =
core regression tests and all 13 PL/pgSQL tests pass.

I hope it=E2=80=99s the last:

-- Case 7: composite variable used in RAISE NOTICE (exec_eval_datum =
path).
create type bug19382_foo5 as (a int, b int);
create function bug19382_test_eval_datum() returns void as $$
declare r bug19382_foo5;
begin
r.b :=3D power(2, 30)::int4;
alter type bug19382_foo5 alter attribute b type text;
raise notice 'r =3D %', r; -- exec_eval_datum called here, no check
end;
$$ language plpgsql;
select bug19382_test_eval_datum();
drop function bug19382_test_eval_datum();
drop type bug19382_foo5 cascade;


Best regards, Andrey Borodin.=