"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