"Marc G. Fournier" <scrappy(at)postgresql(dot)org> writes:
> 'k, this is looking promising ... but I'm a bit confused on the TOAST 
> tables ... I can't match on 'relname', since they aren't the same ... the 
> old has, for instance:

> pg_toast_5773565

> while the new has:

> pg_toast_8709712

> is there some sort of 'linkage' in pg_class that I'm not seeing?

Yeah.  A toast table's OID appears in the reltoastrelid field of its
owning table.  So you match new and old pg_class entries by name,
take their reltoastrelid fields, look up those rows by OID, and their
relfilenode fields give the names of the TOAST files.

			regards, tom lane

In response to

• Re: FATAL: catalog is missing 1 attribute(s) for relid at 2005-01-14 20:45:49 from Marc G. Fournier

Responses

• Re: FATAL: catalog is missing 1 attribute(s) for relid at 2005-01-15 19:54:11 from Marc G. Fournier

pgsql-hackers by date

Next:	From: Martijn van Oosterhout	Date: 2005-01-14 21:28:57
	Subject: Re: MOVE
Previous:	From: Marc G. Fournier	Date: 2005-01-14 20:45:49
	Subject: Re: FATAL: catalog is missing 1 attribute(s) for relid