8.3-beta4, analyze and db owner

Поиск
Список
Период
Сортировка
От Clodoaldo
Тема 8.3-beta4, analyze and db owner
Дата
Msg-id a595de7a0801060326qbfc790ax2a60573043c2e2be@mail.gmail.com
обсуждение исходный текст
Ответы Re: 8.3-beta4, analyze and db owner  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-general
I'm the owner of a database and when i issue an analyze command on it,
the pg tables are skipped with the message that only the owner can
analyze them:

$ psql fahstats -U cpn
Welcome to psql 8.3beta4, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

fahstats=> analyze;
WARNING:  skipping "pg_authid" --- only table or database owner can analyze it
WARNING:  skipping "pg_database" --- only table or database owner can analyze it
WARNING:  skipping "pg_tablespace" --- only table or database owner
can analyze it
WARNING:  skipping "pg_pltemplate" --- only table or database owner
can analyze it
WARNING:  skipping "pg_shdepend" --- only table or database owner can analyze it
WARNING:  skipping "pg_shdescription" --- only table or database owner
can analyze it
WARNING:  skipping "pg_auth_members" --- only table or database owner
can analyze it
ANALYZE
fahstats=> \l
        List of databases
   Name    |  Owner   | Encoding
-----------+----------+-----------
 fahstats  | cpn      | SQL_ASCII
 postgres  | postgres | SQL_ASCII
 template0 | postgres | SQL_ASCII
 template1 | postgres | SQL_ASCII
(4 rows)

Regards, Clodoaldo Pinto Neto

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

Предыдущее
От: Clodoaldo
Дата:
Сообщение: Re: Performance problem. Could it be related to 8.3-beta4?
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: 8.3-beta4, analyze and db owner