On Jan 9, 2004, at 4:15 PM, [EMAIL PROTECTED] 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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
