> It will be tough redesigning the database to use a surrogate key,
> cause it
> links to other tables using this key and I can't lose this
OK. Just keep it in mind for the next database ;-)
> I ran the select query (looking for duplicate data) and the result
> 0 rows. I have also run this copy using just a few records that I
> know are
> unique with the same result.
> Unfortunately these fields do contain spaces and funny characters,
> this be the problem??
Yes, it could be. Certain characters, such as \ and <tab> can cause
COPY to misbehave. Can you post your full tabledef, plus a few lines
of the COPY file?
______AGLIO DATABASE SOLUTIONS___________________________
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
pgsql-novice by date
|Next:||From: Josh Berkus||Date: 2002-04-18 16:08:36|
|Subject: Re: Indexes: which to use BTREE RTREE HASH GIST?|
|Previous:||From: Josh Berkus||Date: 2002-04-18 15:35:02|
|Subject: Re: Multiple Primary Keys|