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 <mail@joeconway.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Jean-Christian Imbeault
Дата:
Сообщение: Full-text index: in japanese?
Следующее
От: Tourtounis Sotiris
Дата:
Сообщение: DB's buffers