[Firebird-devel] Generators vs read-only transactions

[Dmitry Y. <di...@us...>]

All,

Some time ago, Nickolay has committed this change into HEAD (and now
backported into the v1.5.1 branch):

+ if (tdbb->tdbb_transaction && (tdbb->tdbb_transaction->tra_flags &
TRA_readonly)) {
+ CCH_RELEASE(tdbb, &window);
+ ERR_post(isc_read_only_trans, 0);
+ }

It means that now it's prohibited to increment generators in read-only
transactions. I disagree with this change. First of all, it breaks existing
applications. Secondly, generators are outside transaction control and hence
IMO cannot be controlled by the transaction flags. Obviously, both
generators and external tables cannot be modified for a read-only database,
but read-only transaction is completely another story.

Comments, please.


Dmitry