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.