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@selectacast.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@selectacast.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 ?
>>>>
>>>
>