Re: SQL for CREATE ROLE xxx SUPERUSER

Erwin Brandstetter wrote:
> Second example: superusers get an extra line "UPDATE ..." that should
> not be there. Especially as it refers to the OID which would be
> different when recreating the user.
> CREATE ROLE tester2 SUPERUSER;
>
> === quote
> -- Role: "tester2"
>
> -- DROP ROLE tester2;
>
> CREATE ROLE tester2
>  SUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
> UPDATE pg_authid SET rolcatupdate=true WHERE OID=3714960::oid;
> === unquote

Hi Erwin,

The update is supposed to be there - it enables direct catalog updates
for the user - a kind of super-superuser. You're correct about using the
OID though - replaced with the rolname.

Thanks, Dave.