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
Дата
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
Дата: