| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Angel Alvarez <clist(at)uah(dot)es> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Many temporal schemas appearred on my DB |
| Date: | 2008-12-25 16:17:33 |
| Message-ID: | 20081225161733.GA1997@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Angel Alvarez | 2008-12-25 16:27:07 | Re: Many temporal schemas appearred on my DB |
| Previous Message | Angel Alvarez | 2008-12-25 15:57:10 | Many temporal schemas appearred on my DB |