Leyne, Sean escreveu:

> Salut Philippe!
>
>
>> now, if you are inside a read only transaction, you can't
>> insert data into a GTT but GTT are useful to some long
>> running select queries or even to make a set of successive
>> select queries since GTT have a flag and that data are
>> outside the db file, wouldn't be possible to allow insert
>> even on read only transaction ?
>>

I registered this in the tracker. I think Vlad agreed with me on this. :-)

>
> In a read-only transaction? No.
>
> In a read-only *database*? Possibly.
>
>
> I do not see it as correct that a read-only transaction could do
> anything which involves write operations.

I think it should be writable even in read-only transaction. GTT may be
used to do calculations, and they doesn't interfere with the read-only
data, so I see no problem.

--
Adriano dos Santos Fernandes
http://www.firebirdsql.org