Re: when COPY violates Primary Keys

Поиск
Список
Период
Сортировка
От ITAGAKI Takahiro
Тема Re: when COPY violates Primary Keys
Дата
Msg-id 20081010085843.9944.52131E4D@oss.ntt.co.jp
обсуждение исходный текст
Ответ на Re: when COPY violates Primary Keys  (Chris <dmagick@gmail.com>)
Список pgsql-general
Chris <dmagick@gmail.com> wrote:

> Joao Ferreira gmail wrote:
> > in case the COPY of a register causes a primary key (or UNIQUE, or FK)
> > violation does the psql restore command try to continue the operation
> > until it has parsed the whole dump, or does it abort on the first
> > violation ?
>
> Copy is all or nothing. It'll abort as soon as a violation happens.
>
> the bulkloader on pgfoundry (http://pgfoundry.org/projects/pgbulkload/)
> can apparently handle this for you...

No, pg_bulkload is all or nothing for constraints violations.
Please use pgloader (http://pgfoundry.org/projects/pgloader/)
for the purpose.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center



В списке pgsql-general по дате отправления:

Предыдущее
От: Chris
Дата:
Сообщение: Re: when COPY violates Primary Keys
Следующее
От: Martin Pitt
Дата:
Сообщение: Re: [Pkg-postgresql-public] Postgres major version support policy on Debian