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.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
