Chris <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
