"A.M." <age...@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
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
