Re: Storing session-local data - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Storing session-local data
Date
Msg-id 456FF919.8060905@enterprisedb.com
Whole thread Raw
In response to Storing session-local data  (Elijah Epifanov <lists@xmart.ws>)
Responses Re: Storing session-local data
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: FOR SHARE vs FOR UPDATE locks
Next
From: Guillaume Lelarge
Date:
Subject: Re: Notify enhancement