Skip site navigation (1) Skip section navigation (2)

Many temporal schemas appearred on my DB

From: Angel Alvarez <clist(at)uah(dot)es>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Many temporal schemas appearred on my DB
Date: 2008-12-25 15:57:10
Message-ID: (view raw or whole thread)
Lists: pgsql-general

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
Tú lo compras, yo lo copio. Todo legal.


pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2008-12-25 16:17:33
Subject: Re: Many temporal schemas appearred on my DB
Previous:From: Asko OjaDate: 2008-12-25 13:23:22
Subject: Re: Conditional commit inside functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group