Re: pg_temp..

From: "Tom Lane" <tgl@sss.pgh.pa.us>
> "Brian Baquiran" <brianb@edsamail.com> writes:
> > Looking in pg_class, I see some tables named pg_temp.<PID>.1 thru
> > 7. Is it safe to delete these rows from pg_class?
>
> Yes, if the backend PIDs that created 'em aren't around anymore.  I'd
> suggest DROP TABLE rather than a DELETE FROM pg_class.

Tried that. I get "ERROR:  class "pg_temp.6004.0" is a system catalog". Is
it because it starts with "pg_"?

> > I also see old pg_temp* and pg_sorttemp* in the data directory. I guess
I'll
> > be deleting those too.
>
> If you like.

Thanks Tom.

Brian