Re: nooby Q: temp tables good for web apps?
От
Kenneth Tilton
Тема
Re: nooby Q: temp tables good for web apps?
Дата
Msg-id
49DBFA16.4000803@gmail.com
Ответ на
Re: nooby Q: temp tables good for web apps? (Scott Marlowe)
Список
Дерево обсуждения
nooby Q: temp tables good for web apps? Kenneth Tilton <kentilton@gmail.com>
Re: nooby Q: temp tables good for web apps? Tom Lane <tgl@sss.pgh.pa.us>
Re: nooby Q: temp tables good for web apps? Kenneth Tilton <kentilton@gmail.com>
Re: nooby Q: temp tables good for web apps? Greg Smith <gsmith@gregsmith.com>
Re: nooby Q: temp tables good for web apps? Kenneth Tilton <kentilton@gmail.com>
Re: nooby Q: temp tables good for web apps? Scott Marlowe <scott.marlowe@gmail.com>
Re: nooby Q: temp tables good for web apps? Kenneth Tilton <kentilton@gmail.com>
Re: nooby Q: temp tables good for web apps? Scott Marlowe <scott.marlowe@gmail.com>
Re: nooby Q: temp tables good for web apps? Kenneth Tilton <kentilton@gmail.com>
Re: nooby Q: temp tables good for web apps? Erik Jones <ejones@engineyard.com>
Re: nooby Q: temp tables good for web apps? John Cheng <jlcheng@ymail.com>
Re: nooby Q: temp tables good for web apps? Greg Smith <gsmith@gregsmith.com>
Re: nooby Q: temp tables good for web apps? Scott Marlowe <scott.marlowe@gmail.com>
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 по дате отправления