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.
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
