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.