"A.M." <agentm(at)themactionfaction(dot)com> wrote:
> When will postgresql offer "global" temporary tables with data
> which are shared among sessions?
Well, that would certainly be far different from what the standard
calls a temporary table of any flavor. In the standard all temporary
tables are restricted to a single connection, and the scope is:
GLOBAL: Schema always present. Once materialized, present for as
long as the connection exists.
CREATED LOCAL: Schema always present. Once materialized, visible
only within a particular module.
DECLARED LOCAL: No permanent schema. Materialized when declared in a
compound statement (standard BEGIN/END; not related to transaction
boundaries), and automatically dropped on exit from the compound
statement.
Current PostgreSQL temporary tables are sort of a hybrid between
GLOBAL and DECLARED LOCAL temporary tables from the standard.
-Kevin