[EMAIL PROTECTED] wrote:
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.
Hi Dave!
But is the line needed at all?
Clearly it works the same way with just "CREATE ROLE tester SUPERUSER".
LG
Erwin
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
