Re: LOCK TABLE HELP

Sorry for the bad text format. Below the right (I hope...)  text:

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)

{

        ........................................

        ........................................

 & nbsp;      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 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? 

Any Idea?

Thanks in advance.

Luca