Skip site navigation (1) Skip section navigation (2)

Re: CREATE ROLE jdbc vs pgadmin

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: CREATE ROLE jdbc vs pgadmin
Date: 2011-11-17 20:23:15
Message-ID: 4EC56D33.9040009@hogranch.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 11/17/11 11:56 AM, Flávio Alves Granato wrote:
>
> I have a problem with the query 'CREATE ROLE' being executed via jdbc 
> and via pgadmin. When I run it via pgadmin:
>
> CREATE ROLE flavio LOGIN
>   ENCRYPTED PASSWORD 'cd6a0065e497a3c20b3c639df7d56b0d'
>   NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
>
> and via jdbc:
>
> CREATE ROLE flavio LOGIN
>   ENCRYPTED PASSWORD 'md5bf5a1a18f98fd6debde92560c933d2d9'
>   NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
>
> I did update to the newest jdbc:
>
> CREATE ROLE flavio LOGIN
>   ENCRYPTED PASSWORD 'md50eb617ecacedd0cfae723bbe53c75918'
> NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
>
> It would be a bug in jdbc? I am using PostgreSQL 9.1 and linux.

what is the problem?



-- 
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast



In response to

Responses

pgsql-bugs by date

Next:From: Flávio Alves GranatoDate: 2011-11-17 20:31:42
Subject: Re: CREATE ROLE jdbc vs pgadmin
Previous:From: Flávio Alves GranatoDate: 2011-11-17 19:56:56
Subject: CREATE ROLE jdbc vs pgadmin

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group