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

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: List <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: problem: query result in jdbc is <> result in psql
Date: 2012-01-09 18:01:02
Message-ID: 4F0B2B5E.8030703@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I created table a with generate_series.

jks=# \d a
Table "public.a"
Column | Type | Modifiers
-----------------+---------+-----------
generate_series | integer |

I lock it by doing:
jks=# begin; lock table a;
BEGIN
LOCK TABLE

On 01/09/2012 12:49 PM, Dave Cramer wrote:
> Joseph,
>
> Same versions and I am unable to replicate this here. Can you send me
> your schema, and how you are locking it ?
>
>
> Dave Cramer
>
> dave.cramer(at)credativ(dot)ca
> http://www.credativ.ca
>
>
>
> On Mon, Jan 9, 2012 at 12:23 PM, Joseph Shraibman<jks(at)selectacast(dot)net> wrote:
>> PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.6.1
>> 20110908 (Red Hat 4.6.1-9), 64-bit
>>
>>
>> java version is 1.6.0_29
>>
>>
>> On 01/09/2012 07:08 AM, Dave Cramer wrote:
>>>
>>> Joseph,
>>>
>>> I just tried your code using the latest driver and pg 8.4 and 9.1 it
>>> works fine. What version of the server are you using ?
>>>
>>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2012-01-09 18:44:14 Re: problem: query result in jdbc is <> result in psql
Previous Message Radosław Smogura 2012-01-09 17:57:39 Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues