Re: VIEWs and TEMP tables problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Markus Schaber <schabi(at)logix-tt(dot)com>
Cc: Antal Attila <atesz(at)ritek(dot)hu>, pgsql-sql(at)postgresql(dot)org
Subject: Re: VIEWs and TEMP tables problem
Date: 2006-02-16 15:05:15
Message-ID: 28150.1140102315@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Markus Schaber <schabi(at)logix-tt(dot)com> writes:
> Antal Attila wrote:
>> Is it BUG, or FEATURE? Has anybody got good ideas for solve this problem?

> It is a feature.

Right. Note that one possible answer is, after you make the temp table,
to create a temp view referencing the temp table (and hiding the
permanent view in the same way as the temp table hides the permanent table).

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Burke 2006-02-16 15:07:50 Using calculated columns as arguments in same SELECT
Previous Message Daniel Caune 2006-02-16 13:57:20 Re: How to force PostgreSQL using an index