RE: [firebird-support] Re: Transaction access mode (read only vs. read write) from context?

[hv...@users.sourceforge.net [firebird-support]]

Hi András,
 
 > Is it possible to backport this items to 2.5.9? 
 

 >> Firebird3 supports following transaction-related items in 'SYSTEM' 
 >> namespace: 
 >> "TRANSACTION_ID", "ISOLATION_LEVEL", "LOCK_TIMEOUT", "READ_ONLY" 

 

   Should be no problem (if release policy allows), so - welcome to the tracker 
;)
 

 Regards,
 Vlad

RE: [firebird-support] Re: Transaction access mode (read only vs. read write) from context?

[Omacht András aoma...@mve.hu [firebird-support]]

Hi Vlad!

Thank you!

Is it possible to backport this items to 2.5.9?

András

From: 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]