Re: Bug: Unreferenced temp tables disables vacuum to update xid

Joshua D. Drake wrote:
> Alvaro Herrera wrote:

>> Hmm ... that would be strange.  Off-the-cuff idea: we introduced code to
>> advance relfrozenxid in CLUSTER, TRUNCATE and table-rewriting forms of
>> ALTER TABLE.  Perhaps the problem is that we're neglecting to update it
>> for the toast table there.  AFAIR I analyzed the cases and they were all
>> handled, but perhaps I forgot something.
>
> Just to throw another variable into the mix. This machine was a PITR slave 
> that was pushed into production about two weeks ago.

Ah, right, I bet we have a smoking gun here.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support