How to avoid empty temp schemas

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: How to avoid empty temp schemas
Date: 2006-04-24 08:59:19
Message-ID: e2i41a$2hqt$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

After some time of working, Postgres 8.1.3 on W2K creates large a number of
empty schemas in my database.

Those schemas are named pg_temp_1 .. pg_temp_13 (some names are missing in
sequence).

Some of them do not contain any objects. Some contain temp tables created by
my application.

Is it safe to remove those schemas ?

How to force Postgres to remove empty schemas automatically ?

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2006-04-24 09:14:36 How to close dead connections immediately
Previous Message arthurjr07 2006-04-24 08:48:33 Re: Transactions, PostgreSQL and MS Access front end.