Re: triggers, transactions and locks - Mailing list pgsql-general

From C G
Subject Re: triggers, transactions and locks
Date
Msg-id BAY101-F4283DCCDD95419315ACD40C5B40@phx.gbl
Whole thread Raw
In response to Re: triggers, transactions and locks  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-general

> > 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 the commit to release the lock.



pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: triggers, transactions and locks
Next
From: Alvaro Herrera
Date:
Subject: Re: Index bloat in 7.2