From: | "Jaruwan Laongmal" <jaruwan(at)gits(dot)net(dot)th> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | problem with copy command |
Date: | 2001-04-10 08:14:32 |
Message-ID: | 001f01c0c196$46bcb000$6d9a96cb@ntl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
dear all,
I currently using postgresql v7.0.3
when i import text file to table with command "copy tablename from
'/tmp/a.txt';
and it shows
"copy: line 20, Cannot insert a duplicate key into unique index testpri_pk"
,then it exits with doing nothing.
I want to ignore this errors and continue copy the next record. How to do
that?
if I don't filter in '/tmp/a.txt' before using copy command.
Thank you so much for your help in advance .
Regards
Jaruwan
From | Date | Subject | |
---|---|---|---|
Next Message | John Gray | 2001-04-10 09:52:25 | Re: "--tuning" compile and runtime option (?) |
Previous Message | Lehel Gyuro | 2001-04-10 07:31:32 | Maybe a plpgsql bug? |
From | Date | Subject | |
---|---|---|---|
Next Message | Stan van de Mortel | 2001-04-10 08:53:13 | Foreign Key between different databases |
Previous Message | Bruce Momjian | 2001-04-10 03:00:57 | Re: Inheritance Semantics |