"Sim Zacks" <sim@xxxxxxxxxxxxxx> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
