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

Re: Removal of temp tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Removal of temp tables
Date: 2001-06-14 04:52:06
Message-ID: 16255.992494326@sss.pgh.pa.us (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-hackerspgsql-patches
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> I am wondering if pg_temp tables should even be seen as system tables by
> IsSystemRelationName().  We have to call them pg_ so user applications
> don't display them, but other than that they aren't like system tables.
> Comments?

This oughta be discussed on pghackers, not just -patches.  But my
thought is that we need a three-way distinction; at least some of the
IsSystemRelation checks presumably *should* accept temp relnames, else
we'd not have decided to do it that way in the first place.

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.  So it may not be worth adding further
complexity to support the present approach.  We'll just have to rip
it out again ... better to expend the work on making schemas.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-06-14 05:05:51
Subject: Re: [PATCHES] Removal of temp tables
Previous:From: Tom LaneDate: 2001-06-14 04:26:32
Subject: Re: corrupted document in 7.1.2

pgsql-patches by date

Next:From: Bruce MomjianDate: 2001-06-14 05:05:51
Subject: Re: [PATCHES] Removal of temp tables
Previous:From: Bruce MomjianDate: 2001-06-14 04:17:14
Subject: Removal of temp tables

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