Re: nooby Q: temp tables good for web apps? - Mailing list pgsql-general

From Kenneth Tilton
Subject Re: nooby Q: temp tables good for web apps?
Date
Msg-id 49DBFA16.4000803@gmail.com
Whole thread Raw
In response to Re: nooby Q: temp tables good for web apps?  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: nooby Q: temp tables good for web apps?
List 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


pgsql-general by date:

Previous
From: John Cheng
Date:
Subject: Re: nooby Q: temp tables good for web apps?
Next
From: Scott Marlowe
Date:
Subject: Re: nooby Q: temp tables good for web apps?