Thread: Missing data for column

Missing data for column

From
azwa@nc.com.my
Date:
<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> 

Re: Missing data for column

From
Michael Glaesemann
Date:
On Jan 9, 2004, at 4:15 PM, azwa@nc.com.my wrote:

> Hi,
>
> i got an error below after running copy command . the table structure 
> as
> following :
>
>           Table "biosadm.custinv_temp
>    Column    |     Type      |
> -------------+---------------+-
>  yr          | integer       |
>  custname    | text          |
>  invstatus   | text          |
>  custlo      | text          |
>  invno       | integer       |
>  invdate     | date          |
>  amount      | numeric(10,2) |
>  acc         | text          |
>  salesperson | text          |
>
> ERROR:  copy: line 1, Missing data for column "subsidiary"

Could you include the COPY command you're using, as well as the first 
couple of lines of the file you're copying from? It's hard to know what 
the problem is without this.

Regards,

Michael Glaesemann
grzm myrealbox com



Re: Missing data for column

From
azwa@nc.com.my
Date:
<font face="Times New Roman" size="2">Hi,</font><font face="Times New Roman"><br /></font><font face="Times New Roman"
size="2"><br/>  Sorry for the late respond. i've solved my problem. the error comes out when the data has subsidiary
columnbut</font><font face="Times New Roman"> </font><font face="Times New Roman" size="2"><br /> there is no
subsidiarycolumn in table. tq</font><font face="Times New Roman"> </font><br /><br /><br /><table width="100%"><tr
valign="top"><td></td><td><divalign="center"><font face="sans-serif" size="2"><b>Michael Glaesemann
<grzm@myrealbox.com></b></font></div><divalign="center"><p><font face="sans-serif" size="2">01/09/2004 06:54 PM
ZE9</font></div><divalign="center"><br /></div></td><td><font face="sans-serif" size="2">        To:      
 azwa@nc.com.my</font><br/><font face="sans-serif" size="2">        cc:        pgsql-sql@postgresql.org</font><br
/><fontface="sans-serif" size="2">        Subject:        Re: [SQL] Missing data for column</font></td></tr></table><br
/><br/><font face="Courier New" size="2"><br /><br /> On Jan 9, 2004, at 4:15 PM, azwa@nc.com.my wrote:<br /><br />
>Hi,<br /> ><br /> > i got an error below after running copy command . the table structure <br /> > as<br
/>> following :<br /> ><br /> >           Table "biosadm.custinv_temp<br /> >    Column    |     Type    
 |<br/> > -------------+---------------+-<br /> >  yr          | integer       |<br /> >  custname    | text  
      |<br /> >  invstatus   | text          |<br /> >  custlo      | text          |<br /> >  invno       |
integer      |<br /> >  invdate     | date          |<br /> >  amount      | numeric(10,2) |<br /> >  acc    
   | text          |<br /> >  salesperson | text          |<br /> ><br /> > ERROR:  copy: line 1, Missing data
forcolumn "subsidiary"<br /><br /> Could you include the COPY command you're using, as well as the first <br /> couple
oflines of the file you're copying from? It's hard to know what <br /> the problem is without this.<br /><br />
Regards,<br/><br /> Michael Glaesemann<br /> grzm myrealbox com<br /></font><br />