> Philip Crotwell <crotwell@seis.sc.edu> writes:
> > I was vacuuming, but as the owner of the database. When I do that there
> > are messages that should have clued me in, lke
> > NOTICE: Skipping "pg_largeobject" --- only table owner can VACUUM it
>
> > From now on I will vacuum as user postgres, but I wonder if there is a
> > need for individual users to be able to vacuum large obects by themselves.
>
> Good point. More generally, it seems like it might be a good idea to
> allow the owner of an individual database to vacuum all the system
> catalogs in it, even if he's not the superuser. Comments anyone?
Seems db owner should be able to do whatever they want to the non-global
system tables.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026