Re: Storing session-local data

From: Elijah Epifanov <lists(at)xmart(dot)ws>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Storing session-local data
Date: 2006-12-01 09:53:53
Message-ID: 456FFBB1.204@xmart.ws
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2006-12-01 11:06:34 Re: Storing session-local data
Previous Message Guillaume Lelarge 2006-12-01 09:46:31 Re: Notify enhancement