Re: Persistent data per connection

because the connection is never really dropped...
using a connection pool....so it's just reclaimed by the pool on a 
connection.close() or after a  timeout  period

Tom Lane wrote:

>Jeff Amiel  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
>  
>