Re: [GENERAL] LOCK TABLE HELP

luca . ciciriello Fri, 14 Mar 2008 08:22:57 -0700

Sorry for the bad text format. Below the right (I hope...) &nbsp;text:
Hi All.I&#39;m using for the first time the postgres lock utilities, but
brobably I&#39;m doing something of not legal.My action are:void
*Execute(void *pParam){&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
........................................&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
........................................&nbsp;&nbsp; &nbsp; &nbsp;
&nbsp;string tableLock = &quot;BEGIN WORK;&quot;;&nbsp;&nbsp;&nbsp; &nbsp;
&nbsp; &nbsp;tableLock.append(&quot; LOCK TABLE &quot;);&nbsp;&nbsp;&nbsp;
&nbsp; &nbsp; &nbsp;tableLock.append(actorTable);&nbsp;&nbsp;&nbsp; &nbsp;
&nbsp; &nbsp;tableLock.append(&quot; IN ACCESS EXCLUSIVE
MODE;&quot;);&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;res = PQexec(connection,
tableLock.c_str());&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
........................................&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
........................................&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
pObj-&gt;ReturnNotification(static_cast&lt;string&gt;(notify-&gt;relname),connection);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
.........................................&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
.........................................&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
CleanUpBeforeStop(void *pParam);}void CleanUpBeforeStop(void
*pParam){&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
.........................................&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
.........................................&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
res = PQexec(pPti-&gt;conn, &quot;COMMIT WORK;&quot;);}Well, the function
Execute is the detached procedure of a thread. In here I execute the LOCK
command on the table &quot;actorTable&quot;. 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&#39;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?&nbsp;Any Idea?Thanks in
advance.Luca--------- Original Message --------Da: &quot;Richard
Huxton&quot; &lt;[EMAIL PROTECTED]&gt;To: Cc:
[EMAIL PROTECTED]: Re: [GENERAL] LOCK TABLE HELPData:
14/03/08 16:[EMAIL PROTECTED] wrote:&gt; Hi All.&gt; &gt;
I&amp;#39;m using for the first time the postgres lock utilities, but
brobably&gt; I&amp;#39;m doing something of not legal.My action are:void
*Execute(void&gt; *pParam){ ........................................
........................................&amp;nbsp;&amp;nbsp;&gt; &amp;nbsp;
&amp;nbsp; &amp;nbsp;string tableLock = &amp;quot;BEGIN&gt;
WORK;&amp;quot;;&amp;nbsp; &amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp;
&amp;nbsp;tableLock.append(&amp;quot;&gt; LOCK TABLE &amp;quot;);&amp;nbsp;
&amp;nbsp;&amp;nbsp; &amp;nbsp; &amp;nbsp;Could you repost your message
without all the &amp;nbsp stuff? There&#39;s probably a &quot;plain
text&quot; option in your email package you need to turn on.-- Richard
HuxtonArchonet Ltd-- Sent via pgsql-general mailing list
([email protected])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

Re: [GENERAL] LOCK TABLE HELP

Reply via email to