Re: SQL for CREATE ROLE xxx SUPERUSER - Mailing list pgadmin-hackers

From Dave Page
Subject Re: SQL for CREATE ROLE xxx SUPERUSER
Date
Msg-id 46C4714C.4090701@postgresql.org
Whole thread Raw
In response to Re: SQL for CREATE ROLE xxx SUPERUSER  (Erwin Brandstetter <brandstetter@falter.at>)
Responses Re: SQL for CREATE ROLE xxx SUPERUSER  (Erwin Brandstetter <brandstetter@falter.at>)
List pgadmin-hackers
Erwin Brandstetter wrote:
> Hi Dave!
>
> But is the line needed at all?
> Clearly it works the same way with just "CREATE ROLE tester SUPERUSER".

It's not the same thing - pg_authid.rolsuper is the superuser flag,
pg_authid.rolcatupdate is the catalog update flag. It cannot be set with
CREATE or UPDATE ROLE, and is required for even a superuser to directly
update the catalogs (postgres has it by default though).

Regards, Dave.

pgadmin-hackers by date:

Previous
From: Erwin Brandstetter
Date:
Subject: Re: SQL for CREATE ROLE xxx SUPERUSER
Next
From: Erwin Brandstetter
Date:
Subject: Re: SQL for CREATE ROLE xxx SUPERUSER