On Thu, Jun 23, 2005 at 12:27:44PM -0700, David Bear wrote: > > I'm finding the \copy is very brittle. It seems to stop for everyone > little reason. Is there a way to tell it to be more forgiving -- for > example, to ignore extra data fields that might exists on a line? > > Or, to have it just skip that offending record but continue on to the > next. Calling this behavior "brittle" is debatable; some people would call it "reliable": either the whole input validates -- matches what's expected -- or the command rejects it. This might sound unreasonable if a partial load is acceptable, but it's desirable behavior if a partial load is unacceptable. Some would argue that the correct solution is to fix the data, not to make the command that loads the data more forgiving. The developers' TODO list has a few outstanding items to enhance COPY, but I don't know if anybody's working on them: http://www.postgresql.org/docs/faqs.TODO.html * Allow COPY to report error lines and continue This requires the use of a savepoint before each COPY line is processed, with ROLLBACK on COPY failure. * Have COPY return the number of rows loaded/unloaded (?) -- Michael Fuhr http://www.fuhr.org/~mfuhr/
