Re: Stale temp tables

Peter Darley wrote:
> Friends,
>     I've got a whole bunch (8,000 or so) of old stale temp tables that were the
> result of a hung backend.  I can see them using pgAdmin II, but not through
> psql.  Is there any way to dump these guys, should I dump them, are they
> likely to be causing problems?  What should I do about this?

Wow, that is a good question.  You can stop the postmaster and start the
'postgres' binary with the -O option and drop them.  -O is required
because they are system tables.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026