On Tue, Nov 13, 2007 at 08:50:36PM -0800, Willem Buitendyk wrote: > Will Postgresql ever implement an ignore on error feature when bulk > loading data? Currently it is my understanding that any record that > violates a unique constraint will cause the "copy from" command to > halt execution instead of skipping over the violation and logging it > - as is done in Oracle and DB2. > > Are there alternative ways of dealing with this scenario that won't > consume as much time? > > Appreciate any help - would love to migrate away from Oracle. You might try pgloader. :) http://pgfoundry.org/projects/pgloader/ Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
