From: Tom Lane <tgl@sss.pgh.pa.us>
To: jack <datactrl@tpg.com.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: The problems about temporary tables in V7.3.2
Date: Wed, 28 May 2003 21:11:58 -0400
Message-ID: <12585.1054170718@sss.pgh.pa.us> (raw)
In-Reply-To: <001a01c32577$ccee2180$1400a8c0@jac>
References: <001a01c32577$ccee2180$1400a8c0@jac>
"jack" <datactrl@tpg.com.au> writes:
> A view is created with a normal table xx without a schema specified. And
> before using the view, a temporary table xx , which has the same name as the
> normal table xx used by the view. In the same connection session, it
> supposes the view would read the temporary table. But actually it always
> reads the normal table instead of temporary table. The same thing happens to
> the table specified with a schema. If a SELECT statement uses a table with a
> schema specified, the SELECT statement won't read the temporary table when
> it exists with the same name. I just wonder the schema feature just removes
> the access priority of the temporary tables.
This is all the intended behavior.
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, datactrl@tpg.com.au
Subject: Re: The problems about temporary tables in V7.3.2
In-Reply-To: <12585.1054170718@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