Re: nooby Q: temp tables good for web apps?

From: Kenneth Tilton <kentilton(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: nooby Q: temp tables good for web apps?
Date: 2009-04-08 01:12:54
Message-ID: 49DBFA16.4000803@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Marlowe wrote:
> You can use a different method if you need a table available to the
> same session. Create a schema based on the session id, and put your
> temp tables there, only don't call them temp tables. You'll either
> need to make sure you always clean up your temp schema your session
> created or come up with a daemon that comes along every hour or so and
> kills off old schemas that aren't in use anymore.

I am LMAO because Lisp (my server-side lang) does this to noobs, too:
three (at least) ways to do everything. Well, if all things are equal
dropping one schema and not kludging up mangled table names has a lot of
appeal. Thx.

ken

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-04-08 02:13:35 Re: nooby Q: temp tables good for web apps?
Previous Message John Cheng 2009-04-08 00:16:03 Re: nooby Q: temp tables good for web apps?