Version: PostgreSQL 8.2.5 on i686-pc-mingw32 I recently started getting this error message randomly, "could not open relation 42904/42906/42985: Invalid argument". I also got it for a couple of other files. All three files are related to tables that have just a single row each.
I googled the error message and found that this looks like a problem on Windows (which I'm running until we get access to our Linux server) and probably related to anti-virus scanning. Having run Oracle on Windows before, I have experienced the problem with an anti-virus scanner locking a file and causing the database to error. I thought I understood and fixed the problem. Today, I used pgAdmin to Vacuum Analyze the entire database. It flew through this task as my database is fairly small. However, when it got to the three tables that exhibited this error message, it hung. It took maybe 2-3 seconds to vacuum analyze each one of these tables. Now I don't get it. Was there something corrupt in the file and it wasn't related to the anti-virus scanner? Jon ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
