Re: [9.0] On temporary tables

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: Andy Colson <andy(at)squeakycode(dot)net>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: [9.0] On temporary tables
Date: 2010-09-30 14:12:33
Message-ID: AANLkTikm4yyR9ERO4Ky_0N0Nuw0yrixvwkxoOdTpVAep@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/9/30 Andy Colson <andy(at)squeakycode(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2010-09-30 14:13:45 Re: [9.0] On temporary tables
Previous Message Grzegorz Jaśkiewicz 2010-09-30 14:09:34 Re: [9.0] On temporary tables