Postgres Pro
Downloads
Home   >   mailing lists

Many temporal schemas appearred on my DB - Mailing list pgsql-general

From Angel Alvarez
Subject Many temporal schemas appearred on my DB
Date
Msg-id 200812251657.10886.clist@uah.es
Whole thread Raw
Responses Re: Many temporal schemas appearred on my DB  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
Hi

up to 5 chemas... pg_temp_n for (n=1..5) appearred on my pg 8.3 DB.

pgadmin3 refuses to drop them so i have to open a sql editor and run "drop schema pg_tem...".

Also some pg_toast_temp schemas  got created...
¿Why are created and how con i get rid of them without resorting to doing DROPS by hand?


Thanks, Angel


--
No lea este correo si no es necesario. El buen ambiente está en nuestras manos.
->>-----------------------------------------------
    Clist UAH a.k.a Angel
---------------------------------[www.uah.es]-<<--
Tú lo compras, yo lo copio. Todo legal.

pgsql-general by date:

Previous
From: "Asko Oja"
Date:
Subject: Re: Conditional commit inside functions
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Many temporal schemas appearred on my DB