Re: LOCK TABLE HELP

luca.ciciriello@email.it wrote:
> Sorry for delay in my answer. The problem is that with the lock
> instructions my app remain in a freeze state. It resembling a MUTEX
> deadlock.Anyway, as soon as possible I'll test yuor idea to use a
> separate PQexec.

Freeze state?  Oh, you mean like somebody already holds the lock, so
your LOCK TABLE is just waiting for the holder to release it ...

Have a look around the pg_locks view.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support