| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | "Michael A(dot) Mayo" <mmayo(at)mcauleybrooklyn(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Columns in pg_shadow? |
| Date: | 2000-05-21 17:16:39 |
| Message-ID: | 9770.958929399@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Peter Eisentraut <peter_e(at)gmx(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2000-05-21 17:44:48 | Re: Re: MySQL crashme test and PostgreSQL |
| Previous Message | Tom Lane | 2000-05-21 17:10:27 | Re: MySQL's "crashme" (was Re: Performance) |