more fields from MON$ATTACHMENTS table accessible by contexst variables like 
MON$REMOTE_PROCESS..
-------------------------------------------------------------------------------------------------

                 Key: CORE-3448
                 URL: http://tracker.firebirdsql.org/browse/CORE-3448
             Project: Firebird Core
          Issue Type: New Feature
            Reporter: Karol Bieniaszewski


now only two field is accesible by contexst variable from MON$ATTACHEMENTS

MON$ATTACHMENTS_ID is accessible by CURRENT_CONNECTION
MON$USER is accessible by CURRENT_USER

will be good to see more fields in context variables without douing snapshot 
transaction against MON$ATTACHEMENTS table

especially 
  MON$REMOTE_PROCESS
also usefull

  MON$ROLE 
  MON$REMOTE_PID RDB$PID,
  MON$TIMESTAMP RDB$TIMESTAMP


MON$REMOTE_PROCESS can by used to calculate statistics which process do how 
many transactions 
this can by processed by database triggers
but now it can be only obtained by selecting from MON$ATTACHEMENTS which start 
another snapshot transaction

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
Fulfilling the Lean Software Promise
Lean software platforms are now widely adopted and the benefits have been 
demonstrated beyond question. Learn why your peers are replacing JEE 
containers with lightweight application servers - and what you can gain 
from the move. http://p.sf.net/sfu/vmware-sfemails
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to