Does copy abort on a failed insertion?

Поиск
Список
Период
Сортировка
Искать
От
Reid Thompson
Тема
Does copy abort on a failed insertion?
Дата
Msg-id
F71C0DC6B4FD3648815AAA7F969E352901B156DF@sr002-2kexc.ateb.com
Список
Дерево обсуждения
Does copy abort on a failed insertion? "Reid Thompson" <Reid.Thompson@ateb.com>
Re: Does copy abort on a failed insertion? Scott Marlowe <smarlowe@g2switchworks.com>
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 по дате отправления
От: Jim C. Nasby
Дата:
Сообщение: Re: insertion becoming slow
От: Shane Dawalt
Дата:
Сообщение: Re: 8.0.1 SRPM on RHEL v.3
FAQ