| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | luca(dot)ciciriello(at)email(dot)it |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: LOCK TABLE HELP |
| Date: | 2008-03-17 12:57:53 |
| Message-ID: | 20080317125753.GD6083@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
luca(dot)ciciriello(at)email(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dee | 2008-03-17 14:00:02 | Re: Cannot Install PostgreSQL on Windows 2000 Server |
| Previous Message | Pavan Deolasee | 2008-03-17 12:27:36 | Re: 8.3.0 upgrade |