Re: Columns in pg_shadow? - Mailing list pgsql-general

From Tom Lane
Subject Re: Columns in pg_shadow?
Date
Msg-id 9770.958929399@sss.pgh.pa.us
Whole thread Raw
In response to Re: Columns in pg_shadow?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: crash on \copy
Next
From: Richard Smith
Date:
Subject: INSERT WITH SELECT help