Re: New VACUUM FULL crashes on temp relations

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: New VACUUM FULL crashes on temp relations
Дата
Msg-id 27507.1265136931@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: New VACUUM FULL crashes on temp relations  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: New VACUUM FULL crashes on temp relations
Список pgsql-hackers
I wrote:
> Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp> writes:
>> AFAICS, the assertion is broken, but the code is correct. We just need to
>> adjust the expression in the assertion.

> I think this is 100% wrong.  Toast tables shouldn't be changing
> namespace either; which means you broke something somewhere else.

After tracing through it, the problem is that rebuild_relation() assumes
toast tables are always in PG_TOAST_NAMESPACE; which has not been true
since 8.3.  CLUSTER has been renaming temp toast tables into the wrong
namespace right along.  Without the assert to call attention to it, who
knows how long it would've taken to notice :-(

Will fix.
        regards, tom lane


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

Предыдущее
От: Tim Bunce
Дата:
Сообщение: Re: Package namespace and Safe init cleanup for plperl UPDATE 3 [PATCH]
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)