Re: SELECT FOR UPDATE - release lock?

On Thu, May 04, 2006 at 22:08:16 +0200,
  Christian Hofmann <christian.hofmann@gmx.de> wrote:
> Hello,
>
> for some tables I am using a "select a,b,c from mytable where x='abc' FOR
> UPDATE" query to prevent other servers also modify this data while I am
> reading the data and decide to modify the data.
>
> Now sometimes I don't want to make an update. Is there a way to release the
> lock. Or is the lock released by simply call commit?

Locks are released when transactions end.