Re: Re: [JDBC] unlink large objects

> Philip Crotwell <crotwell(at)seis(dot)sc(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026