Missing data for column
| От | azwa@nc.com.my |
|---|---|
| Тема | Missing data for column |
| Дата | |
| Msg-id | OFB73BC10B.0738DF15-ONFFFFFF44.00433FD5@nc.com.my обсуждение исходный текст |
| Ответы |
Re: Missing data for column
|
| Список | 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 по дате отправления: