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