From: Zsolt Parragi <zsolt.parragi@percona.com>
In-Reply-To: 
 <CAOVWO5p5vUZVeRVTANoHY-CpD1L5szk96aKX5hDW-woyOH7DVA@mail.gmail.com>
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>
 <674982B4-2824-433D-AFC4-CCBF410D9424@yandex-team.ru>
 <CAOVWO5r3-yzw=Baamiu-reus8H3tRwxsVMp7cmQmqx_f2+Lo6g@mail.gmail.com>
 <CAOVWO5q0X+fCjb9MSBwR-q6EEM7M_KKEkBvy1kWwuMvX4dyHiQ@mail.gmail.com>
 <CAOVWO5p5vUZVeRVTANoHY-CpD1L5szk96aKX5hDW-woyOH7DVA@mail.gmail.com>
MIME-Version: 1.0
Date: Mon, 6 Jul 2026 15:16:53 -0700
Message-ID: 
 <CAN4CZFM99uKZgZ8fY1vDPTMvmL5MVb19JRiOq95hZ-BUN28kiw@mail.gmail.com>
Subject: Re: BUG #19382: Server crash at __nss_database_lookup
To: pgsql-bugs@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Archived-At: 
 <https://www.postgresql.org/message-id/CAN4CZFM99uKZgZ8fY1vDPTMvmL5MVb19JRiOq95hZ-BUN28kiw%40mail.gmail.com>
Precedence: bulk

Hello!

The following still reproduces the crash with the patch:

create type foo as (a int, b int);
create function bar_rec() returns record as $$
declare r record;
begin
  r := row(123, power(2,30)::int4)::foo;
  alter type foo alter attribute b type text;
  return r;
end $$ language plpgsql;
select bar_rec();

And also, shouldn't the following still work?

create type inn2 as (x int, y int);
create type out2 as (a int, b inn2);
create function fp_test() returns out2 as $$
declare r out2;
begin
  r := row(1, row(10, 20)::inn2)::out2;
  alter type inn2 alter attribute y type text;
  r := row(1, row(10, 'hello')::inn2)::out2;
  return r;
end $$ language plpgsql;
select fp_test();
-- ERROR: cannot return record variable "r" after composite type
"inn2" was altered

but it only uses out2.