Re: Persistent data per connection - Mailing list pgsql-general

From Tom Lane
Subject Re: Persistent data per connection
Date
Msg-id 25311.1111769416@sss.pgh.pa.us
Whole thread Raw
In response to Persistent data per connection  (Jeff Amiel <jamiel@istreamimaging.com>)
Responses Re: Persistent data per connection
List pgsql-general
Jeff Amiel <jamiel@istreamimaging.com> writes:
> We've been struggling for several days now to come up with a mechanism
> that allows us to establish a mechanism to store data that remains
> persistent for the life of the connection.

Why don't you just store it in a temporary table?  Goes away at
connection drop by definition ... and each connection can use the same
name for the temp table, so coding is easy.

            regards, tom lane

pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: [ANNOUNCE] Manitou-Mail
Next
From: Thomas F.O'Connell
Date:
Subject: Re: Referential integrity using constant in foreign key