Postgres Pro
Downloads
Home   >   mailing lists

Does copy abort on a failed insertion? - Mailing list pgsql-general

From Reid Thompson
Subject Does copy abort on a failed insertion?
Date
Msg-id F71C0DC6B4FD3648815AAA7F969E352901B156DF@sr002-2kexc.ateb.com
Whole thread Raw
Responses Re: Does copy abort on a failed insertion?
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: insertion becoming slow
Next
From: Shane Dawalt
Date:
Subject: Re: 8.0.1 SRPM on RHEL v.3