Re: [HACKERS] CREATE TEMP TABLE

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: "[Jos_] Soares" <jose(at)sferacarta(dot)com>, hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] CREATE TEMP TABLE
Date: 1999-05-10 17:29:44
Message-ID: 37371788.8F171225@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > > SQL92 uses TEMPORARY instead, I think it would be
> > > interesting to keep compatibility with SQL Standard.
> > > CREATE [{ GLOBAL | LOCAL } TEMPORARY ] TABLE class_name
> > Bruce, is this OK? If so, I'll put it in (if someone else hasn't
> > already done so).
> We only support LOCAL, I think, because the visibility of the table is
> only local.

OK. I've got patches to include the LOCAL/GLOBAL syntax, and an elog
error if GLOBAL is specified. Will apply soon...

- Tom

--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-05-10 17:31:42 Re: [HACKERS] views and group by (formerly: create view as selec
Previous Message Tom Lane 1999-05-10 17:24:34 Re: [HACKERS] 6.5 cvs ERROR: copyObject: don't know how to copy 604