Обсуждение: Many temporal schemas appearred on my DB

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.

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/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

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.