statement id

From: elein <elein(at)sbcglobal(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: elein(at)varlena(dot)com
Subject: statement id
Date: 2003-03-19 03:03:35
Message-ID: 200303190304.h2J34wnB027418@pimout1-ext.prodigy.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)varlena(dot)com Database Consulting www.varlena.com
I have always depended on the [QA] of strangers.

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-03-19 04:47:23 Re: log_timestamp and SIGHUP?
Previous Message Stephan Szabo 2003-03-19 02:31:35 Re: Referential Integrity problem