8.3-beta4, analyze and db owner - Mailing list pgsql-general

From Clodoaldo
Subject 8.3-beta4, analyze and db owner
Date
Msg-id a595de7a0801060326qbfc790ax2a60573043c2e2be@mail.gmail.com
Whole thread Raw
Responses Re: 8.3-beta4, analyze and db owner
List 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 by date:

Previous
From: Clodoaldo
Date:
Subject: Re: Performance problem. Could it be related to 8.3-beta4?
Next
From: Magnus Hagander
Date:
Subject: Re: 8.3-beta4, analyze and db owner