| 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: | Whole Thread | Raw Message | 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 |