pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

The problems about temporary tables in V7.3.2
2+ messages / 2 participants
[nested] [flat]

* The problems about temporary tables in V7.3.2
@ 2003-05-29 00:17  jack <datactrl@tpg.com.au>
  0 siblings, 1 reply; 2+ messages in thread

From: jack @ 2003-05-29 00:17 UTC (permalink / raw)
  To: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: The problems about temporary tables in V7.3.2
@ 2003-05-29 01:11  Tom Lane <tgl@sss.pgh.pa.us>
  parent: jack <datactrl@tpg.com.au>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2003-05-29 01:11 UTC (permalink / raw)
  To: jack <datactrl@tpg.com.au>; +Cc: pgsql-sql

"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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2003-05-29 01:11 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-29 00:17 The problems about temporary tables in V7.3.2 jack <datactrl@tpg.com.au>
2003-05-29 01:11 ` Tom Lane <tgl@sss.pgh.pa.us>

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