Hi All.
I'm using for the first time the postgres lock utilities, but brobably
I'm doing something of not legal.My action are:void *Execute(void
*pParam){ ........................................
........................................
string tableLock = "BEGIN
WORK;"; tableLock.append("
LOCK TABLE ");
tableLock.append(actorTable);
tableLock.append(" IN ACCESS EXCLUSIVE
MODE;"); res =
PQexec(connection,
tableLock.c_str()); ........................................
........................................
pObj->ReturnNotification(static_cast<string>(notify->relname),connection);
.........................................
......................................... CleanUpBeforeStop(void
*pParam);}void CleanUpBeforeStop(void
*pParam){ .........................................
......................................... res
= PQexec(pPti->conn, "COMMIT WORK;");}Well, the
function Execute is the detached procedure of a thread. In here I
execute the LOCK command on the table "actorTable". Then, in the
method ReturnNotification I read the locked table. At last, calling the
function CleanUpBeforeStop, I execute the COMMIT command.Well, all this
doesn't work (the connection is the 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? Any
Idea?Thanks in advance.Luca
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Una BMW Z4 Roadster a 10? Prova gratis su Bidplaza.it!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7673&d=20080314
