Skip site navigation (1) Skip section navigation (2)

Re: FATAL: catalog is missing 1 attribute(s) for relid 16396

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: FATAL: catalog is missing 1 attribute(s) for relid 16396
Date: 2005-01-14 21:19:47
Message-ID: 26266.1105737587@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
"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

Responses

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group