Igor Tandetnik wrote:
John Stanton <[EMAIL PROTECTED]> wrote:

Predictability is ensured by using transactions.  By using BEGIN and
COMMIT to make transactions atomic you enforce a predictable state.


Not if you modify the same data you are iterating over, on the same DB connection and thus within the same transaction.

Igor Tandetnik

A good point to be aware of when designing for transactional integrity. Read locks are important.

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------



-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to