Forum OpenACS Q&A: Response to Table locks in pltcl functions

Collapse
2: Response to Table locks in pltcl functions (response to 1)
Posted by Peter Harper on 09/13/01 11:41 AM
I believe you probably want a "select ... for update" clause here.
This (assuming postgresql is sensible) will only lock those rows
that were returned from the select, rather than the entire table.

Have a look at the following URL for more information regarding
syntax.
http://www.postgresql.org/idocs/index.php?sql-select.html

Cheers,
Pete.