Chris <dmagick@xxxxxxxxx> 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
