Re: Many temporal schemas appearred on my DB

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.