Re: problem: query result in jdbc is <> result in psql

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: problem: query result in jdbc is <> result in psql
Date: 2012-01-09 22:55:18
Message-ID: jefr8l$2ijf$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2012-01-10 00:41:22 Re: problem: query result in jdbc is <> result in psql
Previous Message Joseph Shraibman 2012-01-09 22:52:47 Re: problem: query result in jdbc is <> result in psql