"Could not open relation XXX: No such file or directory" - Mailing list pgsql-general

From Alan Millington
Subject "Could not open relation XXX: No such file or directory"
Date
Msg-id 851562.13310.qm@web25408.mail.ukl.yahoo.com
Whole thread Raw
Responses Re: "Could not open relation XXX: No such file or directory"  (Craig Ringer <craig@postnewspapers.com.au>)
Re: "Could not open relation XXX: No such file or directory"  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
I am running Postgres 8.1.4 on Windows XP Professional Service Pack 3.
 
Yesterday when attempting to select from one particular database I repeatedly encountered errors such as the following:
 
2009-08-18 10:49:54 ERROR:  could not open relation 1663/51796/1247: No such file or directory
2009-08-18 10:49:54 STATEMENT:  SELECT typname FROM pg_type WHERE oid = 1043
 
1247 is pg_type. In Explorer I could see the file 51796/1247, and the timestamp indicated that it had not recently been updated. I had never previously seen this error.
 
As that database is used only for testing, I dropped it and loaded a new one from a dump. However, earlier today a colleague working against this new database experienced a slightly different error on several occasions:
 
2009-08-19 03:06:45 ERROR:  could not read block 0 of relation 1663/52752/52896: No such file or directory
2009-08-19 03:06:45 STATEMENT:  SELECT * FROM "RP"."RP_ATTRIBUTE" WHERE rp_id = (('MM100')::text)
 
52752/52896 is the Primary Key index on the referenced table. Again, I can see the file in Explorer, and it has not been updated since the database was created. When I try the same Select statement now I get no error.
 
Clearly something is amiss, but I don't know what. I should be grateful for any suggestions as to what I should check.
 

pgsql-general by date:

Previous
From: "Omar Bettin"
Date:
Subject: SPI_ERROR_CONNECT within pl/pgsql PG 8.4
Next
From: Alban Hertroys
Date:
Subject: Re: A history procedure that prevents duplicate entries