Thread: Unexpected NOCREATEROLE clause in role definition

To reproduce:

1. Run command

CREATE ROLE test CREATEROLE

2. Look to the role definition in Group roles.

Observed:

CREATE ROLE test NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;

Expected:

CREATE ROLE test NOSUPERUSER INHERIT NOCREATEDB CREATEROLE;


Platform:

PgAdmin 1.4.1 on Windows XP

"PostgreSQL 8.1.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 
(mingw-special)"

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Andrus
> Sent: 12 January 2006 18:30
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Unexpected NOCREATEROLE clause in
> role definition
>
> To reproduce:
>
> 1. Run command
>
> CREATE ROLE test CREATEROLE
>
> 2. Look to the role definition in Group roles.
>
> Observed:
>
> CREATE ROLE test
>   NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;
>
> Expected:
>
> CREATE ROLE test
>   NOSUPERUSER INHERIT NOCREATEDB CREATEROLE;

Thanks - fixed in SVN trunk and the stable branch.

Regards, Dave