Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Subject: BUG #19431: limitation of the data type jsonb equals 8Kb
To: pgsql-bugs@lists.postgresql.org
From: PG Bug reporting form <noreply@postgresql.org>
Cc: perovaa@sbermarketing.ru
Reply-To: perovaa@sbermarketing.ru, pgsql-bugs@lists.postgresql.org
Date: Thu, 12 Mar 2026 12:11:06 +0000
Message-ID: <19431-0a33306c00df939f@postgresql.org>
Auto-Submitted: auto-generated
Archived-At: <https://www.postgresql.org/message-id/19431-0a33306c00df939f%40postgresql.org>
Precedence: bulk

The following bug has been logged on the website:

Bug reference:      19431
Logged by:          Alex Perov
Email address:      perovaa@sbermarketing.ru
PostgreSQL version: 18.3
Operating system:   Windows 10
Description:       =20

Hello.
I have a type:
CREATE TYPE public.t_dict AS
(
        id bigint,
        name text,
        gid uuid,
        alias text,
        bgcolor text,
        disabled boolean,
        checked boolean,
        options jsonb,
        "order" integer
);
and function
CREATE OR REPLACE FUNCTION public.f_func(data jsonb, uid bigint, context
text =3D null, ext text =3D null, pid bigint =3D null, pgid uuid =3D null)
        returns setof rd.t_dict
        language plpgsql
AS $$
begin
  context :=3D coalesce(context, data->>'context', '');
  ext =3D coalesce(ext, '');

  create temp table tmp_f_table of public.t_dict;
  if dict =3D 'dict1' then
    insert into tmp_f_table (id, name)
      select
          1, name
        from public.tbl1 a;
  elsif dict =3D 'dict2' then
    insert into tmp_f_table (id, name, alias)
      select
          t.objecttypeid, t.objecttype, t.alias
        from public.tbl2 t
        where (t.objecttypeid <> 0)
          and t.active;
  elsif dict =3D 'dict3' then
    insert into tmp_f_table (id, name, options)
    select
          t.linktypeid, t.linktype,
          json_object(
            'rev': t.reftypeid =3D (data->'objecttype')::bigint,
            'items': t.options
          )
        from public.tbl3 t;
  end if;
return query select * from tmp_f_cpdictionary;
  drop table tmp_f_cpdictionary;
end
$$;
when calling a function for dict3, I have an error "could not open relation
with OID 196327".
As far as I know, this is due to a limitation of the data type jsonb equals
8Kb.
Is it possible to fix this error without changing the logic of the code?