Tom Lane <[EMAIL PROTECTED]> writes:
> You should be able to DROP that table even though it doesn't have an
> underlying file. My guess is that you are running atop a non-crash-safe
> filesystem and it lost the directory entry for the just-created file.
> You might want to think about switching to a journaling file system.
In which case you might find them in /lost+found
--
greg
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match