Brian Stempin on 4 Apr 2010 22:40:07 -0700

[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [PLUG] postgres data loading

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.

Philadelphia Linux Users Group         --
Announcements -
General Discussion  --