Querying information_schema [bug?]

Поиск
Список
Период
Сортировка
От Ivan Radovanovic
Тема Querying information_schema [bug?]
Дата
Msg-id 50AFF3FE.4030502@gmail.com
обсуждение исходный текст
Список pgsql-general
Hello,

I couldn't find anything mentioned about this in documentation and
googling didn't help either:
- if I connect to database as user who doesn't have permission to access
all schemas then querying information_schema.schemata returns no rows
(querying information_schema.tables returns only tables from accessible
schemas, and executing \dn from psql returns list of all schemas)

Desk=> select schema_name from information_schema.schemata;
  schema_name
-------------
(0 rows)

Desk=> select distinct table_schema from information_schema.tables;
     table_schema
--------------------
  cards
  information_schema
  pg_catalog
(3 rows)

Desk=> \dn
     List of schemas
       Name      | Owner
----------------+-------
  cards          | pgsql
  help           | pgsql
  public         | pgsql
  storage        | pgsql
(4 rows)

Desk=> select version();
                                                    version

-------------------------------------------------------------------------------------------------------------
  PostgreSQL 9.2.1 on amd64-portbld-freebsd8.3, compiled by cc (GCC)
4.2.1 20070831 patched [FreeBSD], 64-bit
(1 row)

Regards,
Ivan


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

Предыдущее
От: Chris Earle
Дата:
Сообщение: pgAgent reporting success for non-zero results
Следующее
От: Vlad
Дата:
Сообщение: Re: High SYS CPU - need advise