Re: Fwd: [GENERAL] statement id

Yes, this is exactly what I'm looking for.  I was
hoping the connection context information might be
available in one of the stat tables, some SQL variable
or function call.

The ability to have data persist across function calls
without having to resort to C is really very useful,
but having some context information is crucial.

elein

On Saturday 22 March 2003 15:48, Joe Conway wrote:
> elein wrote:
> > Is there any way to find out the statement context in a server function?
> > Is there anyway to find out the transaction context in a server function?
>
> [...snip...]
>
> > If this were a C function, would it be easier to have this information?
>
> I don't know anything about plpython, but I'd guess the info you're
> looking for is not available to it.
>
> In C, I think (but have not tried) you could use
> GetCurrentTransactionId() to put the current transaction id into a
> global variable, and allocate memory for other globals in
> TopTransactionContext. Then use a change in transaction id to signal a
> need to reallocate/reinitialize your globals.
>
> Not sure if this is what you were looking for, but HTH.
>
> Joe

--
----------------------------------------------------------------------------------------
elein@varlena.com     Database Consulting     www.varlena.com             I have always depended on the [QA] of
strangers.