Temporary tables and miscellaneous schemas

From: <btober(at)seaworthysys(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Temporary tables and miscellaneous schemas
Date: 2003-10-12 08:48:56
Message-ID: 64867.66.212.203.144.1065948536.squirrel@$HOSTNAME
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Whenever I create a temporary table, with something like

CREATE TEMPORARY TABLE temptable1 AS SELECT * FROM paid.ad_hoc_query;

New schemas appear, with names like "pg_temp_1". I guess the appearance
of these schemas with "temp" in the name indicates that they are
"temporary" schemas and related to the temporary table creation, but the
schemas persist even after the end of the session in which the temporary
table was created.

What's up with these miscellaneous schemas? Are they in fact related to
the creation of temporary tables? Should they disappear when the session
closes, as should the temporary table? If they continue persisting after
the session closes, how do I get rid of them?

~Berend Tober

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Meskes 2003-10-12 08:57:22 Re: Postgres 7.4 : ECPG not Thread-safe
Previous Message Stephane Charette 2003-10-12 07:17:29 CREATE INDEX question (how to index on "money" field?)