Re: [PATCHES] Removal of temp tables

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] Removal of temp tables
Date: 2001-06-14 15:15:07
Message-ID: Pine.LNX.4.30.0106141712430.767-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Tom Lane writes:

> Another point is that when we implement schemas (= Real Soon Now, I
> trust), the whole business of temprels having different physical and
> logical relnames will go away anyhow. Temp rels will become plain rels
> that live in a temp schema.

I don't think this is the right solution. You should be able to create
temporary tables in any schema you choose (and have permission to). After
all, temporary tables are supposed to act like real tables expect for the
"temporary" aspect.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-06-14 15:23:29 Re: [PATCHES] Removal of temp tables
Previous Message Alex Pilosov 2001-06-14 14:39:32 Re: Re: SELECT Field1 || Field2 FROM Table

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2001-06-14 15:23:29 Re: [PATCHES] Removal of temp tables
Previous Message David D. Kilzer 2001-06-14 14:31:06 [PATCH] Contrib C source for casting MONEY to INT[248] and FLOAT[48]