problem with copy command

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

Responses

Browse pgsql-hackers by date

  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?

Browse pgsql-sql by date

  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