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

OK, tried with 9.1.2 still can't replicate this problem.

Dave Cramer

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

On Mon, Jan 9, 2012 at 1:01 PM, Joseph Shraibman <jks(at)selectacast(dot)net> wrote:
> 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 ?
>>>>
>>>
>