[Zope] PopyDA and DBMS Transactions

Ivan Cornell ivan.cornell@framestore.co.uk
Mon, 18 Dec 2000 14:35:27 +0000


Paolo Quaglia wrote:

> I have two DTML Documents:
>
> first DTML: now called D1
> <dtml-var header>
> ...1st sql statement: select * from customers where name='white'

As I understand it, to exclusively lock a table in postgresql, use SELECT
.... FOR UPDATE, eg:

...1st sql statement: select * from customers where name='white' for update of
customers

Regards,
Ivan