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