On Mon, Jun 8, 2009 at 6:57 AM, Anirban Pal<anirban.pal@newgen.co.in> 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