SQL for CREATE ROLE xxx SUPERUSER

From: Erwin Brandstetter <brandstetter(at)falter(dot)at>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: SQL for CREATE ROLE xxx SUPERUSER
Date: 2007-08-16 14:36:42
Message-ID: 46C460FA.40302@falter.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi developers!

Testing the pgAdmin III 1.8.0 Beta 3 (Aug 10 2007, rev: 6546M). Client
Win XP, host: Debian Etch / PG 8.2.4 and Debian Sarge / PG 8.1.8

The reverse engineered SQL for superusers seems at fault. Applies to
both pg 8.2 and pg 8.1.

First example: everything looks normal:
CREATE ROLE tester;

=== quote
-- Role: "tester"

-- DROP ROLE tester;

CREATE ROLE tester
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
=== unquote

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

Regards
Erwin

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message svn 2007-08-16 14:49:00 SVN Commit by dpage: r6566 - trunk/pgadmin3/pgadmin/frm
Previous Message Dave Page 2007-08-16 14:31:18 Re: pgAdmin III v1.8.0 Beta 3 released