Re: Orphaned temp table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Orphaned temp table
Дата
Msg-id 18770.1330375715@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Orphaned temp table  (Mike Blackwell <mike.blackwell@rrd.com>)
Список pgsql-general
Mike Blackwell <mike.blackwell@rrd.com> writes:
> Autovacuum is complaining about an orphaned temp table.  I believe this was
> created just before a recent PostgreSQL crash.  Is there something I should
> do to clean it up?

You could drop that table manually if you're so inclined (probably need
to be superuser to do so), or just wait for it to go away the next time
some session uses the pg_temp_7 temp schema.  There's nothing terribly
magic there.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Having a problem with RoR-3.1.1 and Pg-9.1
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Having a problem with RoR-3.1.1 and Pg-9.1