8.3-beta4, analyze and db owner

From: Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>
To: "PostgreSQL General ML" <pgsql-general(at)postgresql(dot)org>
Subject: 8.3-beta4, analyze and db owner
Date: 2008-01-06 11:26:07
Message-ID: a595de7a0801060326qbfc790ax2a60573043c2e2be@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-patches

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2008-01-06 11:35:45 Re: 8.3-beta4, analyze and db owner
Previous Message Ivan Sergio Borgonovo 2008-01-06 11:08:58 Re: implicit vs. explicit RETURN when OUT is used

Browse pgsql-patches by date

  From Date Subject
Next Message Magnus Hagander 2008-01-06 11:35:45 Re: 8.3-beta4, analyze and db owner
Previous Message Tom Lane 2008-01-05 23:38:38 Re: OUTER JOIN performance regression remains in 8.3beta4