Elijah Epifanov wrote:
> How can I store session-local data in an efficient way (I need to store
> every primary key/oid value for every changed row using triggers)??
> I tried to use session-local temporary table, but it doesn't work with
> PREPARE TRANSACTION...
We might be able to relax that restriction so that you could use a "on
commit delete rows" or "on commit drop" kind of temporary table in a
global transaction. Would that help you?
Maybe a silly queestion, but are you sure you need 2-phase commit?
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com