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

Error in include template "/var/www/openacs/packages/openacs-bootstrap3-theme/resources/templates/packages/forums/lib/search/search-form": can't read "form:id": no such variable
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.