Re: [GENERAL] LOCK TABLE HELP

2008-03-17 Thread Alvaro Herrera
[EMAIL PROTECTED] wrote: > Sorry for delay in my answer. 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'll test yuor idea to use a > separate PQexec. Freeze state? Oh, you mean like somebody already

Re: [GENERAL] LOCK TABLE HELP

2008-03-17 Thread luca . ciciriello
ro Herrera" <[EMAIL PROTECTED]> To: "Richard Huxton" <[EMAIL PROTECTED]> Cc: pgsql-general@postgresql.org Oggetto: Re: [GENERAL] LOCK TABLE HELP Data: 14/03/08 17:51 > [EMAIL PROTECTED] wrote: > My

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 "); > tableLock

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...)  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: ===

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...)  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

Re: [GENERAL] LOCK TABLE HELP

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

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 achi

Re: [GENERAL] LOCK TABLE HELP

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

[GENERAL] LOCK TABLE HELP

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