From: jack <datactrl@tpg.com.au>
To: pgsql-sql@postgresql.org
Subject: The problems about temporary tables in V7.3.2
Date: Thu, 29 May 2003 10:17:56 +1000
Message-ID: <001a01c32577$ccee2180$1400a8c0@jac> (raw)
Hi All
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.
Jack
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: datactrl@tpg.com.au
Subject: Re: The problems about temporary tables in V7.3.2
In-Reply-To: <001a01c32577$ccee2180$1400a8c0@jac>
* 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