What would cause an error such as "ERROR: cache lookup failed for relation #######"? This happens from time to time (a lot lately) and occurs when trying to insert data from a CSV file. I can then later go back and try importing the same CSV file data and it will be succesful. So there is nothing wrong with the file or the tables. This is really frustrating because we have had a large number of insert problems.
I am using Perl PgPP.pm to connect to the Postgres 7.4 database.