Subject RE: [firebird-support] Re: Transaction access mode (read only vs. read write) from context?
Author Omacht András
Hi Vlad!

Thank you!

Is it possible to backport this items to 2.5.9?

András

From: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com>
Sent: Wednesday, September 12, 2018 6:13 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Transaction access mode (read only vs. read write) from context?



> According to the documentation (https://firebirdsql.org/refdocs/langrefupd20-get-context.html) I can retrive the transaction’s isolation level:

> select rdb$get_context('SYSTEM', 'ISOLATION_LEVEL') from rdb$database

>

> But I need to know the access mode too. Is this possible somehow to know it via contexts?



Firebird3 supports following transaction-related items in 'SYSTEM' namespace:



"TRANSACTION_ID", "ISOLATION_LEVEL", "LOCK_TIMEOUT", "READ_ONLY"



Regards,

Vlad







[Non-text portions of this message have been removed]