Re: [GENERAL] triggers, transactions and locks

2004-12-06 Thread C G
> Is there a way to use locks within a trigger? My example below gives the > error: It's not the lock that's the problem I think. The begin work is failing because you can't start a transaction inside the function. Were you trying to release the lock at the commit in the function? Yes I was using

Re: [GENERAL] triggers, transactions and locks

2004-12-06 Thread Stephan Szabo
On Mon, 6 Dec 2004, C G wrote: > Is there a way to use locks within a trigger? My example below gives the > error: It's not the lock that's the problem I think. The begin work is failing because you can't start a transaction inside the function. Were you trying to release the lock at the commit