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 ?
>>>
>>