Re: New behavior in 7.0

On Tue, 30 May 2000, Robert J. Sprawls wrote:

>     I've worked with 6.5.3 and few other older versions. I've never
> had this happen before. Can some one give some explaination?

> bash-2.03$ psql -d sprawlsr -c "vacuum"
> NOTICE:  Skipping "pg_type" --- only table owner can VACUUM it
[more of that]
> NOTICE:  Skipping "pg_tables" --- only table owner can VACUUM it
> VACUUM

Uh, only table owners can vacuum tables, so you have to be the superuser
to run a complete vacuum on a database. Try psql's -U option to set the
user.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden