temp tables for more than one connection - Mailing list pgsql-general

From Jan Hartmann
Subject temp tables for more than one connection
Date
Msg-id DIEALLGCLLCNIHBDCMAEIELBCDAA.jhart@frw.uva.nl
Whole thread Raw
In response to Re: Cross-Tab queries in postgres?  (Joe Conway <mail@joeconway.com>)
List 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 by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Full-text index: in japanese?
Next
From: Tourtounis Sotiris
Date:
Subject: DB's buffers