Cache lookup error when using jsonb, json_build_object and a WITH clause - Mailing list pgsql-hackers

From Michael Paquier
Subject Cache lookup error when using jsonb, json_build_object and a WITH clause
Date
Msg-id CAB7nPqQQMSM-JVuNKZX66R1NK9JyxD4AxG48Cr-pwOmHiegp2A@mail.gmail.com
Whole thread Raw
Responses Re: Cache lookup error when using jsonb, json_build_object and a WITH clause
Re: Cache lookup error when using jsonb, json_build_object and a WITH clause
List pgsql-hackers
Hi all,

I found the following error when playing with jsonb and json_build_object:
=# with jsonb_data as (select * from jsonb_each('{"aa" :
"po"}'::jsonb)) select json_build_object(key,value) from jsonb_data;
ERROR:  XX000: cache lookup failed for type 2147483650
LOCATION:  lookup_type_cache, typcache.c:193

I would have expected the result to be the same as in the case of json:
=# with json_data as (select * from json_each('{"aa" : "po"}'::json))
select json_build_object(key,value) from json_data;json_build_object
-------------------{"aa" : "po"}
(1 row)

Regards,
-- 
Michael



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: default opclass for jsonb (was Re: Call for GIST/GIN/SP-GIST opclass documentation)
Next
From: Fujii Masao
Date:
Subject: Re: New pg_lsn type doesn't have hash/btree opclasses