Re: strange error

qry_Customers_Country is a view.
There is no row in pg_class with relfilenode=7973197 either when it
works or after I get the error.
The version (from select version()) is
PostgreSQL 8.0.1 on i686-pc-linux-gnu, compiled by GCC i686-pc-linux-gnu-gcc (GCC) 3.3.5  (Gentoo Linux 3.3.5-r1,
ssp-3.3.2-3,pie-8.7.7.1) 


Thank You
Sim Zacks


________________________________________________________________________________

"Sim Zacks" <sim@compulab.co.il> writes:
> I am receiving the following error and cannot understand what it means.
> Please let me know if this makes sense to you.

> ERROR:  could not open relation 1663/3364852/7973197: No such file or
> directory
> CONTEXT:  SQL statement "create temporary table tmpcust as select a.* from
> qry_Customers_Country a"
> PL/pgSQL function "buildsrtemptables" line 34 at execute statement

That's pretty darn odd.  Is qry_Customers_Country a temp table, plain
table, view, or what?  What PG version is this exactly, running on what
platform?  When the error happens, can you find any row in pg_class with
relfilenode equal to the third number mentioned (7973197 above), and if
so what table is it?

                        regards, tom lane