Re: problem: query result in jdbc is <> result in psql - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: problem: query result in jdbc is <> result in psql
Date
Msg-id CADK3HH+2u4ZcK-iXA61HfghVTr9sigohcX1xb-FjFbzTZQcaqg@mail.gmail.com
Whole thread Raw
In response to Re: problem: query result in jdbc is <> result in psql  (Joseph Shraibman <jks@selectacast.net>)
Responses Re: problem: query result in jdbc is <> result in psql  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-jdbc
Try connecting to the postgres database as the postgres user.

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca



On Mon, Jan 9, 2012 at 5:55 PM, Joseph Shraibman <jks@selectacast.net> wrote:
> On 01/09/2012 05:52 PM, Joseph Shraibman wrote:
>>
>> On 01/09/2012 01:44 PM, Dave Cramer wrote:
>>>
>>> OK, tried with 9.1.2 still can't replicate this problem.
>>>
>> Found the problem. When connecting with jdbc I was connecting to
>> template1, when connecting with psql I was connecting to a different
>> database. When connecting to template1 I can't view the relname from the
>> other database, even though its the same user.
>>
> The problem being that when I'm connected to a different database selecting
> on pg_catalog in my database isn't going to give me the correct result.
>
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc

pgsql-jdbc by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: problem: query result in jdbc is <> result in psql
Next
From: "John T. Dow"
Date:
Subject: resultset.getXXX methods return current row even if on insert row