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){       
........................................       
........................................      
 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--------- Original Message --------Da: "Richard
Huxton" <dev(at)archonet(dot)com>To: Cc:
pgsql-general(at)postgresql(dot)orgOggetto: Re: [GENERAL] LOCK TABLE HELPData:
14/03/08 16:35luca(dot)ciciriello(at)email(dot)it wrote:> 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 "); 
      Could you repost your message
without all the &nbsp stuff? There's probably a "plain
text" option in your email package you need to turn on.-- Richard
HuxtonArchonet Ltd-- 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=20080314