Re: copy notice

Do you have an extra delimiter at the end of the record?

-----Original Message-----
From: muratmy(at)hotmail(dot)com [mailto:muratmy(at)hotmail(dot)com]
Sent: Thursday, February 21, 2002 5:55 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] copy notice

Hi ,
I load a | delimited text file into a table using the following command :
copy table_name from '/usr/local/pgsql/table_name.dat' using delimiters '|';

and get this notice for each row :

NOTICE: copy: line 21579, CopyReadNewline: extra fields ignored

but the rows are loaded succesfully, why do I get this notice ?

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)