From: Tom Lane <tgl@sss.pgh.pa.us>
To: Markus Schaber <schabi@logix-tt.com>
Cc: Antal Attila <atesz@ritek.hu>
Cc: pgsql-sql@postgresql.org
Subject: Re: VIEWs and TEMP tables problem
Date: Thu, 16 Feb 2006 10:05:15 -0500
Message-ID: <28150.1140102315@sss.pgh.pa.us> (raw)
In-Reply-To: <43F46C5E.8090806@logix-tt.com>
References: <43F4617E.9060708@ritek.hu>
<43F46C5E.8090806@logix-tt.com>
Markus Schaber <schabi@logix-tt.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, schabi@logix-tt.com, atesz@ritek.hu
Subject: Re: VIEWs and TEMP tables problem
In-Reply-To: <28150.1140102315@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox