Re: [PLUG] postgres data loading

[Brian Stempin <brian.stempin@gmail.com>]

I just had a thought (mark the calendar).  Are constraints turned on during import?  You mentioned earlier that dups are your biggest pain.  Perhaps the answer might be to import without constraints, attempt to add constrains, and then query for errors/anomalies when applying constraints fails.  At least then, you don't have to reattempt imports -- you can fix the data in-place and retry applying constraints/keys.

Brian
___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug