temp tables for more than one connection
От
Jan Hartmann
Тема
temp tables for more than one connection
Дата
Msg-id
DIEALLGCLLCNIHBDCMAEIELBCDAA.jhart@frw.uva.nl
Ответ на
Re: Cross-Tab queries in postgres? (Joe Conway)
Список
Дерево обсуждения
Re: Cross-Tab queries in postgres? Joe Conway <mail@joeconway.com>
Hello, Is there a way in PostgreSQL to create unique table names? I need them for multi-frame web-browser requests. Each frame calls a PHP script; the first frame creates a table based on an (expensive) query, the other frames use the table in parallel, and when finished, a final frame deletes the table. Each frame executes with its own database connection, so temporary tables cannot be used (or can they in some way?). I can generate names at the client side, but is there a simple way to do so within the database, e.g. by writing a pl/pgsql of C function? Thanks in advance, Jan Hartmann
В списке pgsql-general по дате отправления