RE: [Firebird-devel] Generators vs read-only transactions

[Paul B. <pa...@wa...>]

> 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.

I agree with your disagreement, if you understand what I mean.

Paul