statement id - Mailing list pgsql-general

From elein
Subject statement id
Date
Msg-id 200303190304.h2J34wnB027418@pimout1-ext.prodigy.net
Whole thread Raw
List pgsql-general
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?

I have a plpython function I want to run and it can store data for the
context of a session.  But I only want the memory to last the duration
of a statement or a transaction.  It is not a trigger function which has
a transaction dictionary.  If I knew the statement or transaction id I could
initialize the memory for multiple calls within the session.
Statement (subselect) level would be best as it would enable managing
data from several calls to the same function.  Sort of.

If this were a C function, would it be easier to have this information?

thanks,

elein


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

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Referential Integrity problem
Next
From: Tom Lane
Date:
Subject: Re: log_timestamp and SIGHUP?