Re: Updating pg_attribute - Permission denied

> "Trewern, Ben" <Ben(dot)Trewern(at)mowlem(dot)com> writes:
> > Looks like I have turned off usecatupd in pg_shadow. Doh! Was mucking
> > around with permissions some time ago but not had any trouble up till now.
> > Any ideas how to switch it back? Update pg_shadow SET usecatupd ..... gives
> > me Permission denied!!!
>
> Catch-22, ain't it? I think the only workaround at the moment is to
> create a new user with superuser privileges (who will have usecatupd
> true), become him, and fix your own usecatupd via UPDATE. Then you
> can discard the new superuser identity.
>
> A cleaner solution would be to have an ALTER USER variant that allows
> setting/clearing usecatupd. Item for TODO list ...

Added:

* Add ALTER USER command to change user db attributes

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