Re: copy notice

On Thu, 2002-02-21 at 10:54, my wrote:
> 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 ?

You have probably managed to escape the new line at the end of that
particular line in the input file, so that it is tagging the first part
of line 21580 onto the end of the last field.  The rest of line 21580
gets thrown away.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "My sheep hear my voice, and I know them, and they
      follow me; And I give unto them eternal life; and they
      shall never perish, neither shall any man pluck them
      out of my hand."          John 10:27,28