Re: Getting fancy errors when accessing information_schema on 10.5

Поиск
Список
Период
Сортировка
От Axel Rau
Тема Re: Getting fancy errors when accessing information_schema on 10.5
Дата
Msg-id E45BA9F7-91F8-488D-8D25-5879AEC91725@Chaos1.DE
обсуждение исходный текст
Ответ на Re: Getting fancy errors when accessing information_schema on 10.5  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin


Am 30.10.2018 um 13:58 schrieb Tom Lane <tgl@sss.pgh.pa.us>:

Axel Rau <Axel.Rau@Chaos1.DE> writes:
Am 30.10.2018 um 13:17 schrieb Tom Lane <tgl@sss.pgh.pa.us>:
It doesn't happen for me either.  Looking at the planner code, it seems
like the relkind check should happen first because it'd be cheaper than
the OR condition.  Have you perhaps messed with the cost attributed to
pg_has_role(), has_sequence_privilege(), or chareq()?

Not by intention. The instance has some history, it go back to 8.x I think.

You could investigate with, eg,

select oid::regprocedure, procost from pg_proc
where proname = 'has_sequence_privilege';

nextcloud=> select oid::regprocedure, procost from pg_proc
nextcloud->  where proname = 'has_sequence_privilege';
                 oid                   | procost
----------------------------------------+---------
has_sequence_privilege(name,text,text) |       1
has_sequence_privilege(name,oid,text)  |       1
has_sequence_privilege(oid,text,text)  |       1
has_sequence_privilege(oid,oid,text)   |       1
has_sequence_privilege(text,text)      |       1
has_sequence_privilege(oid,text)       |       1
(6 rows)

Hm, nothing surprising there, but what about the other two?

nextcloud=> select oid::regprocedure, procost from pg_proc
 where proname = 'pg_has_role';
             oid             | procost 
-----------------------------+---------
 pg_has_role(name,name,text) |       1
 pg_has_role(name,oid,text)  |       1
 pg_has_role(oid,name,text)  |       1
 pg_has_role(oid,oid,text)   |       1
 pg_has_role(name,text)      |       1
 pg_has_role(oid,text)       |       1
(6 rows)

nextcloud=> select oid::regprocedure, procost from pg_proc
 where proname = 'chareq';
          oid          | procost 
-----------------------+---------
 chareq("char","char") |       1
(1 row)

nextcloud=>

Axel
---
PGP-Key:29E99DD6  ☀  computing @ chaos claudius

В списке pgsql-admin по дате отправления:

Предыдущее
От: Christoph Berg
Дата:
Сообщение: Re: creating table without columns
Следующее
От: Tom Lane
Дата:
Сообщение: Re: creating table without columns