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

From Joseph Shraibman
Subject Re: problem: query result in jdbc is <> result in psql
Date
Msg-id jefr8l$2ijf$1@news.hub.org
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  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
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.

pgsql-jdbc by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: problem: query result in jdbc is <> result in psql
Next
From: Dave Cramer
Date:
Subject: Re: problem: query result in jdbc is <> result in psql