If i have a pg_dump that is using COPY, and midway through the copy an insert fails due to a unique constraint, will the COPY continue with the rest of the records, or will it abort? If it aborts, will it perform a rollback on the inserts up to that point? thanks, reid ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly