On Mon, Jun 8, 2009 at 6:57 AM, Anirban Pal<anirban.pal@xxxxxxxxxxxx> wrote: > Dear all, > > Our software use postgres as backend database. It works fine, strange thing > is that, it creates so many temporary schemas under schema tab, names like > pg_toast, pg_toast_temp_1 like this upto pg_toast_temp40. This schemas also > reflected in "pg_namespace" table. Can anybody tell me, is there anything > wrong in it? Should I get rid of these temporary schemas? Any suggestion > on this, please. you are a purist, bad habit. Anything beginning with pg_* is an internal schema, don't touch it, and no - you can't get rid of it. -- GJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general