| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | perovaa(at)sbermarketing(dot)ru |
| Subject: | BUG #19431: limitation of the data type jsonb equals 8Kb |
| Date: | 2026-03-12 12:11:06 |
| Message-ID: | 19431-0a33306c00df939f@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 19431
Logged by: Alex Perov
Email address: perovaa(at)sbermarketing(dot)ru
PostgreSQL version: 18.3
Operating system: Windows 10
Description:
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 = null, ext text = null, pid bigint = null, pgid uuid = null)
returns setof rd.t_dict
language plpgsql
AS $$
begin
context := coalesce(context, data->>'context', '');
ext = coalesce(ext, '');
create temp table tmp_f_table of public.t_dict;
if dict = 'dict1' then
insert into tmp_f_table (id, name)
select
1, name
from public.tbl1 a;
elsif dict = '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 = 'dict3' then
insert into tmp_f_table (id, name, options)
select
t.linktypeid, t.linktype,
json_object(
'rev': t.reftypeid = (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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2026-03-12 12:40:12 | Re: BUG #19428: Lazy evaluation of type checking in CASE in SQL functions including subqueries no longer works in 18 |
| Previous Message | cca5507 | 2026-03-12 11:33:36 | Re: Two issues with REFRESH MATERIALIZED VIEW CONCURRENTLY |