LOCK TABLE HELP

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