SQL for CREATE ROLE xxx SUPERUSER

Поиск
Список
Период
Сортировка
От Erwin Brandstetter
Тема SQL for CREATE ROLE xxx SUPERUSER
Дата
Msg-id 46C460FA.40302@falter.at
обсуждение исходный текст
Ответы Re: SQL for CREATE ROLE xxx SUPERUSER  (Dave Page <dpage@postgresql.org>)
Список 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

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: svn@pgadmin.org
Дата:
Сообщение: SVN Commit by guillaume: r6565 - trunk/www/locale/fr_FR/LC_MESSAGES
Следующее
От: svn@pgadmin.org
Дата:
Сообщение: SVN Commit by dpage: r6566 - trunk/pgadmin3/pgadmin/frm