Re: idea: global temp tables - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: idea: global temp tables
Date
Msg-id 49F6E199.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: idea: global temp tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: idea: global temp tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote: 
> GLOBAL/LOCAL TEMP TABLE distinction is not related to cross-session
> persistence of the table definitions
On a re-read, I think I see your point -- it is the DECLARE LOCAL TEMP
TABLE versus CREATE { GLOBAL | LOCAL } TEMP TABLE which determines
whether the table definition is persisted.  Both forms of CREATE TEMP
TABLE should persist the definition if you go by the standard, so you
don't want to muddy the waters by complying on one and not the other?
-Kevin


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: idea: global temp tables
Next
From: Tom Lane
Date:
Subject: Re: idea: global temp tables