Re: ERROR: _mdfd_getrelnfd: cannot open relation pg_temp_15300_53: No such file or directory

Thanks again.
----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrew Bartley" <abartley(at)evolvosystems(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, October 22, 2002 9:30 AM
Subject: Re: [GENERAL] ERROR: _mdfd_getrelnfd: cannot open relation
pg_temp_15300_53: No such file or directory

> "Andrew Bartley" <abartley(at)evolvosystems(dot)com> writes:
> > I have tried to but together a shell script to touch these files. But
it
> > seems that the table in question has a second pg_toast oid associated
with
> > it.
>
> That's interesting ... if both those physical files went away while the
> pg_class rows remained, it suggests some systematic problem rather than
> just a random glitch. I doubt we'll be able to learn anything about the
> cause if we're not allowed into the database machine though :-(
>
> Anyway, the pg_class.reltoastrelid field for the temp table gives you
> the OID of the pg_class row for its TOAST table, from which you can get
> the relfilenode value to touch for the TOAST table.
>
> Very likely, the TOAST table's index has got the same disease: to find
> it, get the reltoastidxid field from the TOAST table's pg_class row, and
> again go to that OID in pg_class to see its relfilenode value.
>
> (Actually, in 7.2 you'll almost certainly find that relfilenode of each
> of these rows matches its OID, but to be perfectly safe you should look
> up and use the relfilenode.)
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>