From: | luca(dot)ciciriello(at)email(dot)it |
---|---|
To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Richard Huxton <dev(at)archonet(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: LOCK TABLE HELP |
Date: | 2008-03-17 07:51:36 |
Message-ID: | 5ff66fb34ebe46a5a11bca1db080cc14@85.18.140.153 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
Thanks.Luca. --------- Original Message -------- Da: "Alvaro
Herrera" <alvherre(at)commandprompt(dot)com> To: "Richard
Huxton" <dev(at)archonet(dot)com> Cc:
pgsql-general(at)postgresql(dot)org Oggetto: Re: [GENERAL] LOCK TABLE HELP Data:
14/03/08 17:51 > luca(dot)ciciriello(at)email(dot)it wrote: > My action
are: > > void *Execute(void *pParam) > { >
........................................ >
........................................ > > & nbsp; string
tableLock = "BEGIN WORK;"; > tableLock.append("
LOCK TABLE "); > tableLock.append(actorTable); >
tableLock.append(" IN ACCESS EXCLUSIVE MODE;"); > res =
PQexec(connection, tableLock.c_str()); > Well, all this doesn't
work (the connection is th e always the same in > all methods and
functions). Have I to Lock the table, perform some > operation on this
table, and unlock the table all in the same function > scope? What do
you mean it doesn't work? How exactly it fails? If anything, I'd
suggest to send the LOCK TABLE in a separate PQexec() call from BEGIN WORK.
-- Alvaro Herrera
http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom
Development, 24x7 support -- Sent via pgsql-general mailing list
(pgsql-general(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Scopri le tue passioni con Leonardo.it!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7615&d=20080317
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2008-03-17 08:05:31 | Re: How to silence psql notices, warnings, etc.? |
Previous Message | Adam Rich | 2008-03-17 07:13:55 | 8.3.0 upgrade |