statement id

Поиск
Список
Период
Сортировка
От elein
Тема statement id
Дата
Msg-id 200303190304.h2J34wnB027418@pimout1-ext.prodigy.net
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Referential Integrity problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: log_timestamp and SIGHUP?