Re: LOCK TABLE HELP

[Richard Huxton <dev@xxxxxxxxxxxx>]

luca.ciciriello@xxxxxxxx wrote:
> 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

Nope, sorry. Still full of HTML stuff. Hang on, I'll see if I can fix it.

Luca's message below:
=====================


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

--
  Richard Huxton
  Archonet Ltd

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general