Thread: Missing data for column
<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>
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
<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 />