Hi, Does the psql's \copy command run as a transaction? I think it does, but somehow when I cancel (in a script) a running import, "seems" (I can't seem to duplicate it on the cli though) like a few lines/rows gets inserted anyway.. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings