Re: [GENERAL] LOCK TABLE HELP

2008-03-17 Thread luca . ciciriello
;Alvaro Herreraquot; lt;[EMAIL PROTECTED]gt; To: quot;Richard Huxtonquot; lt;[EMAIL PROTECTED]gt; Cc: pgsql-general@postgresql.orgOggetto: Re: [GENERAL] LOCK TABLE HELP Data: 14/03/08 17:51 gt; [EMAIL PROTECTED] wrote: gt; My action are: gt; gt; void *Execute(void

Re: [GENERAL] LOCK TABLE HELP

2008-03-17 Thread Alvaro Herrera
[EMAIL PROTECTED] wrote: Sorry for delay in my answer.nbsp;The problem is that with the lock instructions my app remain in a freeze state. It resembling a MUTEX deadlock.Anyway, as soon as possible I#39;ll test yuor idea to use a separate PQexec. Freeze state? Oh, you mean like somebody

[GENERAL] LOCK TABLE HELP

2008-03-14 Thread luca . ciciriello
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;string

Re: [GENERAL] LOCK TABLE HELP

2008-03-14 Thread Richard Huxton
[EMAIL PROTECTED] wrote: 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;

Re: [GENERAL] LOCK TABLE HELP

2008-03-14 Thread Craig Ringer
[EMAIL PROTECTED] wrote: Well, all this doesn't work (the connection is the always the same in all methods and functions). I do not understand this statement. There are some other things you could mention that might help: Why do you need these table level locks - what are you trying to

Re: [GENERAL] LOCK TABLE HELP

2008-03-14 Thread luca . ciciriello
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;

Re: [GENERAL] LOCK TABLE HELP

2008-03-14 Thread Richard Huxton
[EMAIL PROTECTED] wrote: 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 Nope, sorry. Still full of HTML stuff. Hang on, I'll see if I can fix it. Luca's message below: = I'm

Re: [GENERAL] LOCK TABLE HELP

2008-03-14 Thread Alvaro Herrera
[EMAIL PROTECTED] wrote: My action are: void *Execute(void *pParam) { nbsp; string tableLock = BEGIN WORK;; tableLock.append( LOCK TABLE );

Re: [GENERAL] LOCK TABLE HELP

2008-03-14 Thread Richard Huxton
Richard Huxton wrote: [EMAIL PROTECTED] wrote: 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 Nope, sorry. Still full of HTML stuff. Hang on, I'll see if I can fix it. Luca's message below: