strange (maybe) behaviour of table lock

From: Edoardo Panfili <edoardo(at)aspix(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: strange (maybe) behaviour of table lock
Date: 2006-12-08 15:16:03
Message-ID: 457981B3.8010809@aspix.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a question regarding a strange behaviour (for me, maybe that this
is desidered feature) of LOCK on tables. I am using postgres 8.2

I have a servlet that uses connection pools.
The servlet do "LOCK table,table2,table3,table4"
then do some select (I am testing the code, I will put the update in the
future) an then I close instruction and connection.

The first 4 executions of the servlet goes well, the 5th hangs.
Afther that I use "psql" to do the last query (the one that hangs the
system) of the servlet, also psql hangs.

I did a modify of the servlet
"LOCK table,table2,table3,table4 IN EXCLUSIVE MODE" and no other
modifications. I stop and restart my system, all works well.

Can someone tell me if this is a desidered behaviour? (and if is
possible why). If may help I can post all the queryes and table
structure, they are a little long.

Thank you
Edoardo Panfili

--
edoardo(at)aspix(dot)it
AIM: edoardopn
Jabber: edoardopa(at)talk(dot)google(dot)com
tel:075 9142766

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Evans 2006-12-08 15:16:34 creating functions with variable argument lists
Previous Message Martijn van Oosterhout 2006-12-08 14:48:00 Re: LISTEN / NOTIFY