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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
