relfilenode on 7.2.3

From: "muteki" <muteki_f(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: relfilenode on 7.2.3
Date: 2004-04-02 23:19:28
Message-ID: LAW10-OE49vFQPzhv6L000147e5@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I would like to know for all the entries inside pg_class table (except for
shared tables and views), does the relfilenode field always correspond to a
physical file on the disk at a given moment? Could there be any
inconsistency between the table entry and the actual file? Or this is only
true when the database is fresh started up without any active connection?
Or there is no guarantee at all?

Also, I have seen some posts earlier regarding to can't drop a certain table
because of the corrupted database, Tom suggests deleting the entry inside
pg_class. Is that enough for 7.2.3? Will vacuum automatically do the
actual clean up for those unlinked indexes/physical files? I remember once
I have to do something to pg_type or some other tables. If that's not
enough, what other tables I should pay attention to as well?

http://archives.postgresql.org/pgsql-general/2002-10/msg01371.php

Thanks,

--muteki

Browse pgsql-general by date

  From Date Subject
Next Message Randall Skelton 2004-04-02 23:21:34 Re: Casting int to bool with join...
Previous Message Manfred Koizar 2004-04-02 23:06:57 Re: Compound keys and foreign constraints