Re: Catching exceptions from COPY

On Wed, 28 May 2008, Darren Reed wrote:

> Is it feasible to add the ability to catch exceptions from COPY?

Depends on what you consider feasible. There's a start to a plan for that
on the TODO list: http://www.postgresql.org/docs/faqs.TODO.html but it's
not trivial to implement.

It's also possible to do this right now using pgloader:
http://pgfoundry.org/projects/pgloader/ That requires some setup and
there's overhead to passing through that loading layer.

A third possibility is to write a short script specifically aimed at your
copy need that breaks your input files into smaller chunks and loads them,
kicking back the ones that don't load, or breaking them into even smaller
chunks until you've found the problem line or lines.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD