Re: New VACUUM FULL crashes on temp relations
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>, Simon Riggs <simon@2ndQuadrant.com>, pgsql-hackers@postgresql.org
Date: 2010-02-02T18:55:31Z
Lists: 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