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

Thanks Tom,

I have already done this on our local site.

We have one remote site I do not have access to.

We are able to apply patches to this site only.  Is there an automated way
of doing this.

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.

How do I find this relation in the pg_ tables?

The version of postgres we are running is 7.2

Thanks

Andrew




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


> "Andrew Bartley" <abartley@evolvosystems.com> writes:
> > Is there someone who knows how to fix this?
> >
> > 2002-10-16 14:29:08 [18326]  ERROR:  _mdfd_getrelnfd: cannot open
> > relation
> > pg_temp_15300_53: No such file or directory
>
> Depending on which PG version you are running, you may be able to just
> drop that temp table.  If that doesn't work, create a dummy file to
> match it, and then drop it.  You need a command like
>
> touch $PGDATA/base/DBOID/FILENODE
>
> where DBOID is the OID of your database as seen in pg_database, and
> FILENODE is the pg_class.relfilenode value for the temp table.
>
> regards, tom lane
>
>