Missing data for column

From: azwa(at)nc(dot)com(dot)my
To: pgsql-sql(at)postgresql(dot)org
Subject: Missing data for column
Date: 2004-01-09 07:15:01
Message-ID: OFB73BC10B.0738DF15-ONFFFFFF44.00433FD5@nc.com.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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"

Does anybody have an idea??? TQ

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Daniel Lau 2004-01-09 07:35:20 Type conversion from TEXT to DOUBLE PRECISION
Previous Message Tom Lane 2004-01-09 05:49:45 Re: Date select question...