[EMAIL PROTECTED] 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
