Cache lookup error when using jsonb, json_build_object and a WITH clause

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Cache lookup error when using jsonb, json_build_object and a WITH clause
Дата
Msg-id CAB7nPqQQMSM-JVuNKZX66R1NK9JyxD4AxG48Cr-pwOmHiegp2A@mail.gmail.com
обсуждение исходный текст
Ответы 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
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: default opclass for jsonb (was Re: Call for GIST/GIN/SP-GIST opclass documentation)
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: New pg_lsn type doesn't have hash/btree opclasses