Subject | AW: AW: [firebird-support] transaction the hundreth |
---|---|
Author | Olaf Kluge |
Post date | 2011-06-14T06:52:45Z |
Thank you.
with best regards
Olaf Kluge
Firebird will not read uncommitted records *except* records created by
the current transaction. In other words, you see your own change
immediately, but don't see other transactions' changes until they are
committed (for read committed) or until you start a new transaction
(for concurrency and consistency).
And, all triggers file immediately as rows change. The standard
provides for other trigger firing times (end of statement and commit,
I think), but Firebird's triggers aways fire immediately before (for
before action triggers) or after the row change.
Good luck,
Ann
[Non-text portions of this message have been removed]
with best regards
Olaf Kluge
Firebird will not read uncommitted records *except* records created by
the current transaction. In other words, you see your own change
immediately, but don't see other transactions' changes until they are
committed (for read committed) or until you start a new transaction
(for concurrency and consistency).
And, all triggers file immediately as rows change. The standard
provides for other trigger firing times (end of statement and commit,
I think), but Firebird's triggers aways fire immediately before (for
before action triggers) or after the row change.
Good luck,
Ann
[Non-text portions of this message have been removed]