On Thu, 2005-09-29 at 14:28, Reid Thompson wrote: > 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? Copies are all or nothing. Either the whole set gets inserted or none of it. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
