Try connecting to the postgres database as the postgres user.
On Mon, Jan 9, 2012 at 5:55 PM, Joseph Shraibman <jks(at)selectacast(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pgsql-jdbc by date
|Next:||From: John T. Dow||Date: 2012-01-10 05:48:05|
|Subject: resultset.getXXX methods return current row even if on insert row|
|Previous:||From: Joseph Shraibman||Date: 2012-01-09 22:55:18|
|Subject: Re: problem: query result in jdbc is <> result in psql|