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

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Cache lookup error when using jsonb, json_build_object and a WITH clause
Дата
в 15:42:56
Msg-id
20582.1399650169@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Cache lookup error when using jsonb, json_build_object and a WITH clause Michael Paquier <michael.paquier@gmail.com>
Re: Cache lookup error when using jsonb, json_build_object and a WITH clause Andres Freund <andres@2ndquadrant.com>
Re: Cache lookup error when using jsonb, json_build_object and a WITH clause Tom Lane <tgl@sss.pgh.pa.us>
Re: Cache lookup error when using jsonb, json_build_object and a WITH clause Tom Lane <tgl@sss.pgh.pa.us>
Re: Cache lookup error when using jsonb, json_build_object and a WITH clause Andres Freund <andres@2ndquadrant.com>
Re: Cache lookup error when using jsonb, json_build_object and a WITH clause Tom Lane <tgl@sss.pgh.pa.us>
Re: Cache lookup error when using jsonb, json_build_object and a WITH clause Andrew Dunstan <andrew@dunslane.net>
Re: Cache lookup error when using jsonb, json_build_object and a WITH clause Tom Lane <tgl@sss.pgh.pa.us>
Re: Cache lookup error when using jsonb, json_build_object and a WITH clause Tom Lane <tgl@sss.pgh.pa.us>
Andres Freund  writes:
>> Anybody see other problems to fix here?

> Yea.
> 5)
>      if (val_type > FirstNormalObjectId)
> isn't fundamentally incorrect but imo shouldn't be replaced by something
> like !IsCatalogType() (akin to IsCatalogRelation). At least if we decide
> that hunk is safe from other POVs - I am not actually 100% sure yet.

I didn't particularly like that either.  The test is off-by-one, for
one thing (a type created right at OID wraparound could have
FirstNormalObjectId).  However, it seems reasonable to avoid fruitless
syscache searches for builtin types, and I'm not seeing a lot of point
to wrapping this test in some macro.
		regards, tom lane


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Robert Haas
Дата:
FAQ