Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group