> "Trewern, Ben" <Ben.Trewern@mowlem.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@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026