Re: idea: global temp tables

"A.M." <agentm@themactionfaction.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