On Feb 4, 2005, at 21:32, Joolz wrote:
What I need is an import where all valid lines from the csv files are read into the db, and I also get a logfile for all invalid lines, stating the line number plus the pg error message so I can see which constraint was violated.
I can't think of a direct, elegant solution for this, does anyone have any suggestions? Thanks a lot!
I don't know if it's elegant or not, but my approach to this situation is to read the data into a temp table that does not have as strict constraints. Once the data is in the database, I process it further, moving the data that's valid into the appropriate table. Then I see what's left, and what further processing I need to do to "fix" the invalid data. Perhaps a similar strategy would work for you.
Michael Glaesemann grzm myrealbox com
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
