X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 0A3BFD1B457
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  9 Jan 2004 07:37:06 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 62337-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  9 Jan 2004 03:36:18 -0400 (AST)
Received: from domino.nc.com.my (domino.nc.com.my [202.185.214.131])
	by svr1.postgresql.org (Postfix) with ESMTP id E5318D1B461
	for <pgsql-sql@postgresql.org>; Fri,  9 Jan 2004 03:36:14 -0400 (AST)
Subject: Missing data for column
To: pgsql-sql@postgresql.org
X-Mailer: Lotus Notes Release 5.0 (Intl) 30 March 1999
Message-ID: <OFB73BC10B.0738DF15-ONFFFFFF44.00433FD5@nc.com.my>
From: azwa@nc.com.my
Date: Fri, 9 Jan 2004 15:15:01 +0800
X-MIMETrack: Serialize by Router on domino/ANSI(Release 5.0.5 |September 22,
	2000) at 01/09/2004 03:15:05 PM,
	Serialize complete at 01/09/2004 03:15:05 PM
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=_alternative 0029F2D748256E16_="
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=1.8 tagged_above=0.0 required=5.0 tests=HTML_40_50,
	NO_REAL_NAME
X-Spam-Level: *
X-Archive-Number: 200401/67
X-Sequence-Number: 16460

This is a multipart message in MIME format.
--=_alternative 0029F2D748256E16_=
Content-Type: text/plain; charset="us-ascii"

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
--=_alternative 0029F2D748256E16_=
Content-Type: text/html; charset="us-ascii"




<br><font size=2 face="Times New Roman">Hi,</font>
<br>
<br><font size=2 face="Times New Roman">i got an error below after running copy command . the table structure as following :</font>
<br>
<br><font size=2 face="Times New Roman">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Table &quot;biosadm.custinv_temp</font>
<br><font size=2 face="Times New Roman">&nbsp; &nbsp;Column &nbsp; &nbsp;| &nbsp; &nbsp; Type &nbsp; &nbsp; &nbsp;|</font>
<br><font size=2 face="Times New Roman">-------------+---------------+-</font>
<br><font size=2 face="Times New Roman">&nbsp;yr &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| integer &nbsp; &nbsp; &nbsp; |</font>
<br><font size=2 face="Times New Roman">&nbsp;custname &nbsp; &nbsp;| text &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|</font>
<br><font size=2 face="Times New Roman">&nbsp;invstatus &nbsp; | text &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|</font>
<br><font size=2 face="Times New Roman">&nbsp;custlo &nbsp; &nbsp; &nbsp;| text &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|</font>
<br><font size=2 face="Times New Roman">&nbsp;invno &nbsp; &nbsp; &nbsp; | integer &nbsp; &nbsp; &nbsp; |</font>
<br><font size=2 face="Times New Roman">&nbsp;invdate &nbsp; &nbsp; | date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|</font>
<br><font size=2 face="Times New Roman">&nbsp;amount &nbsp; &nbsp; &nbsp;| numeric(10,2) |</font>
<br><font size=2 face="Times New Roman">&nbsp;acc &nbsp; &nbsp; &nbsp; &nbsp; | text &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|</font>
<br><font size=2 face="Times New Roman">&nbsp;salesperson | text &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|</font>
<br>
<br><font size=2 face="Times New Roman">ERROR: &nbsp;copy: line 1, Missing data for column &quot;subsidiary&quot;</font>
<br>
<br><font size=2 face="Times New Roman">Does anybody have an idea??? TQ</font>
--=_alternative 0029F2D748256E16_=--