Missing data for column - Mailing list pgsql-sql

From azwa@nc.com.my
Subject Missing data for column
Date
Msg-id OFB73BC10B.0738DF15-ONFFFFFF44.00433FD5@nc.com.my
Whole thread Raw
Responses Re: Missing data for column
List pgsql-sql
<br /><font face="Times New Roman" size="2">Hi,</font><br /><br /><font face="Times New Roman" size="2">i got an error
belowafter running copy command . the table structure as following :</font><br /><br /><font face="Times New Roman"
size="2">         Table "biosadm.custinv_temp</font><br /><font face="Times New Roman" size="2">   Column    |     Type
    |</font><br /><font face="Times New Roman" size="2">-------------+---------------+-</font><br /><font face="Times
NewRoman" size="2"> yr          | integer       |</font><br /><font face="Times New Roman" size="2"> custname    | text
        |</font><br /><font face="Times New Roman" size="2"> invstatus   | text          |</font><br /><font
face="TimesNew Roman" size="2"> custlo      | text          |</font><br /><font face="Times New Roman" size="2"> invno
     | integer       |</font><br /><font face="Times New Roman" size="2"> invdate     | date          |</font><br
/><fontface="Times New Roman" size="2"> amount      | numeric(10,2) |</font><br /><font face="Times New Roman"
size="2"> acc        | text          |</font><br /><font face="Times New Roman" size="2"> salesperson | text        
 |</font><br/><br /><font face="Times New Roman" size="2">ERROR:  copy: line 1, Missing data for column
"subsidiary"</font><br/><br /><font face="Times New Roman" size="2">Does anybody have an idea??? TQ</font> 

pgsql-sql by date:

Previous
From: Daniel Lau
Date:
Subject: Type conversion from TEXT to DOUBLE PRECISION
Next
From: Tom Lane
Date:
Subject: Re: Type conversion from TEXT to DOUBLE PRECISION