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
|
Список | 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 по дате отправления: