Many temporal schemas appearred on my DB

On Thu, Dec 25, 2008 at 04:57:10PM +0100, Angel Alvarez wrote:

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?

They are created to store temporary tables. Is there a particular
reason why you want to delete them? The system automatically recycles
them as needed.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

El Jueves, 25 de Diciembre de 2008 Martijn van Oosterhout escribió:

On Thu, Dec 25, 2008 at 04:57:10PM +0100, Angel Alvarez wrote:

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?

They are created to store temporary tables. Is there a particular
reason why you want to delete them? The system automatically recycles
them as needed.

Have a nice day,

they disturbs me when im working on pgadmin. I thought they were stale pieces left for some runs...

Thanks fro the response

--
Agua para todo? No, Agua para Todos.
->>-----------------------------------------------
Clist UAH a.k.a Angel
---------------------------------[www.uah.es]-<<--
MySQL5: Vale, corromper los datos de forma silente no era una buena idea despues de todo.