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

From Elijah Epifanov
Subject Re: Storing session-local data
Date
Msg-id 456FFBB1.204@xmart.ws
Whole thread Raw
In response to Re: Storing session-local data  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Responses Re: Storing session-local data  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
List pgsql-hackers
That would definitely help )))

2) Question isn't silly)) I don't need it right now, but may (with high 
degree of probability) need it in future.

Heikki Linnakangas wrote:
> 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?
> 


pgsql-hackers by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Notify enhancement
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: Storing session-local data