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
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 |
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 |