Re: [COMMITTERS] pgsql: Sequences were not being shown due to the use of lowercase `s`

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [COMMITTERS] pgsql: Sequences were not being shown due to the use of lowercase `s`
Дата
Msg-id 13928.1157409996@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [COMMITTERS] pgsql: Sequences were not being shown due to the use of lowercase `s`  ("Greg Sabino Mullane" <greg@turnstep.com>)
Ответы Re: [COMMITTERS] pgsql: Sequences were not being shown due to the use of lowercase `s`  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список pgsql-hackers
"Greg Sabino Mullane" <greg@turnstep.com> writes:
> Tom Lane replied:
>> What became of my objection that the test should be on USAGE privilege
>> for the containing schema instead?

> I took a stab at implementing this, but what exactly would we check? Looks
> like all the temp tables have automatic usage for the same user, according to

> SELECT *,has_schema_privilege(oid,'USAGE') FROM pg_namespace;

Well, if you test it as a superuser, it's going to return TRUE every
time.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [COMMITTERS] pgsql: sslinfo contrib module - information about current SSL
Следующее
От: Tom Lane
Дата:
Сообщение: Erratic failures on buildfarm member leveret