Re: SQL for CREATE ROLE xxx SUPERUSER

[Dave Page <dpage(at)postgresql(dot)org>]

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.