Re: [GENERAL] ERROR: must be superuser to alter superusers

2007-09-24 Thread Scott Marlowe
On 9/24/07, Philippe Lang <[EMAIL PROTECTED]> wrote: > Hi, > > I had the very bad idea of removing the "superuser" flag from the > "pgsql" role. Now each time I try to set it back, with: That's kind of the equivalent of locking your keys in the car... > Since there is no superuser in the database

[GENERAL] ERROR: must be superuser to alter superusers

2007-09-24 Thread Philippe Lang
Hi, I had the very bad idea of removing the "superuser" flag from the "pgsql" role. Now each time I try to set it back, with: ALTER ROLE pgsql SUPERUSER; ... I get: ERROR: must be superuser to alter superusers SQL state: 42501 Since there is no superuser in the database engine anymore, what