How to avoid empty temp schemas - Mailing list pgsql-general

From Andrus
Subject How to avoid empty temp schemas
Date
Msg-id e2i41a$2hqt$1@news.hub.org
Whole thread Raw
List 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.



pgsql-general by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: How to have a blind-superuser
Next
From: "SunWuKung"
Date:
Subject: isnumeric - checking if text variable is convertable to numeric