Rod Taylor <[EMAIL PROTECTED]> writes: > At some point it must have failed in copying the data across, aborted, > and restarted.
Unless you had an actual backend crash, that's not an adequate
explanation. Transaction abort does clean up created files.
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
