Re: Temp rows - is it possible?

From: TANIDA Yutaka <tanida(at)sra(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Mattias Kregert" <mattias(at)kregert(dot)se>, "Boris Popov" <boris(at)procedium(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Temp rows - is it possible?
Date: 2003-11-11 00:19:16
Message-ID: 20031111091530.45B3.TANIDA@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom,

On Mon, 10 Nov 2003 09:39:32 -0500
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> >> select * from a; # You can get both global and temporary values.
>
> I don't think it's actually reliable. B was meant to be a temp table,
> right?

Ugh.... Yes.

create *temp* table b() inherits (a);

--
TANIDA Yutaka <tanida(at)sra(dot)co(dot)jp>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2003-11-11 00:33:24 Re: ERROR: out of free buffers: time to abort!
Previous Message Shridhar Daithankar 2003-11-11 00:05:53 Re: starting the server at boot