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 8034ED1DA8A
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 12 Jan 2004 01:29:33 +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 52879-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 11 Jan 2004 21:29:04 -0400 (AST)
Received: from domino.nc.com.my (domino.nc.com.my [202.185.214.131])
	by svr1.postgresql.org (Postfix) with ESMTP id 73651D1DA7D
	for <pgsql-sql@postgresql.org>; Sun, 11 Jan 2004 21:28:55 -0400 (AST)
Subject: Re: Missing data for column
To: pgsql-sql@postgresql.org
X-Mailer: Lotus Notes Release 5.0 (Intl) 30 March 1999
Message-ID: <OF7123F548.A73B3489-ONFFFFFF47.0021D6F6@nc.com.my>
From: azwa@nc.com.my
Date: Mon, 12 Jan 2004 09:07:41 +0800
X-MIMETrack: Serialize by Router on domino/ANSI(Release 5.0.5 |September 22,
	2000) at 01/12/2004 09:07:46 AM,
	Serialize complete at 01/12/2004 09:07:46 AM
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=_alternative 0008536548256E19_="
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200401/86
X-Sequence-Number: 16479

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

Hi, 

  Sorry for the late respond. i've solved my problem. the error comes out 
when the data has subsidiary column but 
there is no subsidiary column in table. tq 




Michael Glaesemann <grzm@myrealbox.com>
01/09/2004 06:54 PM ZE9

        To:     azwa@nc.com.my
        cc:     pgsql-sql@postgresql.org
        Subject:        Re: [SQL] Missing data for column



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


--=_alternative 0008536548256E19_=
Content-Type: text/html; charset="us-ascii"



<font size=2 face="Times New Roman">Hi,</font><font face="Times New Roman"> <br>
</font><font size=2 face="Times New Roman"><br>
 &nbsp;Sorry for the late respond. i've solved my problem. the error comes out when the data has subsidiary column but</font><font face="Times New Roman"> </font><font size=2 face="Times New Roman"><br>
there is no subsidiary column in table. tq</font><font face="Times New Roman"> </font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td>
<div align=center><font size=2 face="sans-serif"><b>Michael Glaesemann &lt;grzm@myrealbox.com&gt;</b></font></div>
<div align=center>
<p><font size=2 face="sans-serif">01/09/2004 06:54 PM ZE9</font></div>
<div align=center>
<br></div>
<td><font size=2 face="sans-serif">&nbsp; &nbsp; &nbsp; &nbsp; To: &nbsp; &nbsp; &nbsp; &nbsp;azwa@nc.com.my</font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp; &nbsp; &nbsp; cc: &nbsp; &nbsp; &nbsp; &nbsp;pgsql-sql@postgresql.org</font>
<br><font size=2 face="sans-serif">&nbsp; &nbsp; &nbsp; &nbsp; Subject: &nbsp; &nbsp; &nbsp; &nbsp;Re: [SQL] Missing data for column</font></table>
<br>
<br><font size=2 face="Courier New"><br>
<br>
On Jan 9, 2004, at 4:15 PM, azwa@nc.com.my wrote:<br>
<br>
&gt; Hi,<br>
&gt;<br>
&gt; i got an error below after running copy command . the table structure <br>
&gt; as<br>
&gt; following :<br>
&gt;<br>
&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Table &quot;biosadm.custinv_temp<br>
&gt; &nbsp; &nbsp;Column &nbsp; &nbsp;| &nbsp; &nbsp; Type &nbsp; &nbsp; &nbsp;|<br>
&gt; -------------+---------------+-<br>
&gt; &nbsp;yr &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| integer &nbsp; &nbsp; &nbsp; |<br>
&gt; &nbsp;custname &nbsp; &nbsp;| text &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br>
&gt; &nbsp;invstatus &nbsp; | text &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br>
&gt; &nbsp;custlo &nbsp; &nbsp; &nbsp;| text &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br>
&gt; &nbsp;invno &nbsp; &nbsp; &nbsp; | integer &nbsp; &nbsp; &nbsp; |<br>
&gt; &nbsp;invdate &nbsp; &nbsp; | date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br>
&gt; &nbsp;amount &nbsp; &nbsp; &nbsp;| numeric(10,2) |<br>
&gt; &nbsp;acc &nbsp; &nbsp; &nbsp; &nbsp; | text &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br>
&gt; &nbsp;salesperson | text &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|<br>
&gt;<br>
&gt; ERROR: &nbsp;copy: line 1, Missing data for column &quot;subsidiary&quot;<br>
<br>
Could you include the COPY command you're using, as well as the first <br>
couple of lines 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>
--=_alternative 0008536548256E19_=--