Re: LOCK TABLE HELP

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