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