agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: azwa@nc.com.my
To: pgsql-sql@postgresql.org
Subject: Missing data for column
Date: Fri, 9 Jan 2004 15:15:01 +0800
Message-ID: <OFB73BC10B.0738DF15-ONFFFFFF44.00433FD5@nc.com.my> (raw)

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

view thread (7+ messages)  latest in thread

Message-ID: <OFB73BC10B.0738DF15-ONFFFFFF44.00433FD5@nc.com.my>
Permalink:  ../OFB73BC10B.0738DF15-ONFFFFFF44.00433FD5@nc.com.my/
Also on:    postgresql.org/message-id/OFB73BC10B.0738DF15-ONFFFFFF44.00433FD5@nc.com.my

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: azwa@nc.com.my
  Subject: Re: Missing data for column
  In-Reply-To: <OFB73BC10B.0738DF15-ONFFFFFF44.00433FD5@nc.com.my>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox