SELECT FOR UPDATE - release lock? - Mailing list pgsql-novice

From Christian Hofmann
Subject SELECT FOR UPDATE - release lock?
Date
Msg-id 00e801c66fb6$7b91edd0$7b00a8c0@taschenrechner
Whole thread Raw
Responses Re: SELECT FOR UPDATE - release lock?
List pgsql-novice
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?

The problem is, that we are using collection pooling. So these datasets
(where x='xyz') would be blocked forever.
How would you solve this? What can i do?

Thank you,

Christian



pgsql-novice by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: SQL Order Question
Next
From:
Date:
Subject: Re: SQL Order Question