"Harald Armin Massa" <[EMAIL PROTECTED]> wrote > > 2005-11-21 09:45:50 ERROR: could not open relation 1663/17253/43471: No > such > file or directory > > My checking showed that... within directory data/base/17253 there is > indeed > no file named 43471; but ones named 43470,43472,43473 ..... >
This may be not a direct step to solve the problem, but let's get some feelings first: Is 43471 a temp table? To find out this: "select relname, nspname from pg_class, pg_namespace where pg_namespace.oid=pg_class.relnamespace and relfilenode = 43471;" Regards, Qingqing ---------------------------(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