Roberts, Jon wrote: > 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.
This has been reported before, and we've patched the system so that the error reported is better. In HEAD we also patched it so that the system would automatically retry a number of times if the problem is ERROR_SHARING_VIOLATION (or something like that). That patch was not backported to 8.2 due to lack of testing -- the original reported did not come back to try the patched version. If you want to try, the patch is here: https://projects.commandprompt.com/public/pgsql/changeset/29853 Let us know how it goes. If your problem is easily reproducible and the patch makes it go away, we would consider back-patching the fix. Thanks. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
