Does copy abort on a failed insertion?

From: "Reid Thompson" <Reid(dot)Thompson(at)ateb(dot)com>
To: "Postgres general mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: Does copy abort on a failed insertion?
Date: 2005-09-29 19:28:44
Message-ID: F71C0DC6B4FD3648815AAA7F969E352901B156DF@sr002-2kexc.ateb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shane Dawalt 2005-09-29 19:42:23 Re: 8.0.1 SRPM on RHEL v.3
Previous Message Craig 2005-09-29 18:08:17 pl/pgsql function debugging