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@xxxxxxxxx> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
Attachment:
signature.asc
Description: Digital signature
