Peter Eisentraut <peter_e@gmx.net> writes:
>>>> usecatupd:
>>>> Ability to change system tables?
>> Since there's no really convenient interface for twiddling this flag,
>> I doubt anyone actually bothers to change it. It starts out the same
>> as one's usesuper flag, and probably stays that way...
> Also note that once you unset this flag you can't set it again because you
> no longer have write access to pg_shadow.
Yeek. Gun ... foot ... shoot ...
I suppose you'd still have the rights to create new users, so you could
create a new superuser and then log in as him to fix the problem.
regards, tom lane