Re: [9.0] On temporary tables - Mailing list pgsql-general

From Vincenzo Romano
Subject Re: [9.0] On temporary tables
Date
Msg-id AANLkTikm4yyR9ERO4Ky_0N0Nuw0yrixvwkxoOdTpVAep@mail.gmail.com
Whole thread Raw
In response to Re: [9.0] On temporary tables  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
2010/9/30 Andy Colson <andy@squeakycode.net>:
> On 9/30/2010 8:52 AM, Vincenzo Romano wrote:
>>
>> I was also thinking about using the catalog, but it looked to me
>> "easier" my way.
>> And, of course, if you have better advises for a "session variables"
>> solution, my ears are open.
>
> More of a question: why use temp tables at all?  What does that offer that a
> single, regular, session table does not?

In my mind it can be a good and simple solution when I have more than
1 user needing a
set of "personal" variables for each connection/session.

Better advises are welcome, of course.

--
Vincenzo Romano at NotOrAnd Information Technologies
Software Hardware Networking Training Support Security
--
NON QVIETIS MARIBVS NAVTA PERITVS

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: [9.0] On temporary tables
Next
From: Pavel Stehule
Date:
Subject: Re: [9.0] On temporary tables