what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: what is difference between LOCAL and GLOBAL TEMP TABLES in PostgreSQL
Date: 2007-07-01 21:31:22
Message-ID: 162867790707011431u71e53543x19e64e5bb160b124@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

Hello

if I understand well, there isn't any difference between local and
global temp tables in postgresql.

I have question. Is correct implementation of global temp in Oracle or
Firebird, where content of glob.temp table is session visible and
metadata of g.t.t is persistent? Standard is unclean and speak more
about local temp tables.

"The materialization of a temporary table does not persist beyond the
end of the SQL-session in which the table was materialized. Temporary
tables are effectively empty at the start of an SQL-session.' -- It
means so temp table exists on the start of session.

What is your opinion about implementation this feature into postgresql
(persistent temp tables)?

Regards
Pavel Stehule

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-07-01 21:40:42 Re: Restartable signals 'n all that
Previous Message Martijn van Oosterhout 2007-07-01 21:17:15 Re: Restartable signals 'n all that