Re: Persistent data per connection

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Amiel <jamiel(at)istreamimaging(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Persistent data per connection
Date: 2005-03-25 16:50:16
Message-ID: 25311.1111769416@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff Amiel <jamiel(at)istreamimaging(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas F.O'Connell 2005-03-25 16:51:45 Re: Referential integrity using constant in foreign key
Previous Message Daniel Verite 2005-03-25 16:44:38 [ANNOUNCE] Manitou-Mail