pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Sebastian Tewes <stewes@tewes.homelinux.net>
To: pgsql-sql@postgresql.org
Subject: invalid input syntax for integer: ""
Date: Sat, 1 May 2004 00:44:40 +0200
Message-ID: <000801c42f04$ba09b6f0$0a0010ac@2864id> (raw)

Hello :-)

got a little prob... 

so my table 

create table warengruppen ( kennung char (1),
                                holder int,
                     HauptWarenGruppe int,
                        BezHWG varchar (50),
                          WarenGruppe int,
                         BezWG varchar (50));


the copy syntax 

copy warengruppen FROM '/usr/pgsql/datanorm.wrg' with DELIMITER ';';

and a smal part of my 'datanorm.wrg'


S;;011;Dachsteine+Formst.;;;
S;;011;;0111;Dachst.glatt(Biber);
S;;011;;0112;Dachst.glatt(Tegal.);
S;;011;;0114;Dachst.mulde(Donau);
S;;011;;0116;Dachst.symm.(Frankf);
S;;011;;0118;Dachst.asym.(Dop.-S);
S;;011;;0119;Dachst.Sonstige;
S;;012;Dachziegel+Formst.;;;
S;;012;;0121;Biberschwanzziegel;
S;;012;;0122;Hohlz.+Krempz.;
S;;012;;0123;Mnch + Nonne;
S;;012;;0124;Strangfalzziegel;
S;;012;;0125;Falzz.(Doppelmulde);
S;;012;;0126;Flachdachziegel;
S;;012;;0127;Verschiebeziegel;
S;;012;;0129;Ziegel Sonstige;
S;;013;Faserzementplatten;;;
S;;013;;0131;Dach+Fassadenplatten;
S;;013;;0133;Wellplatten;
S;;013;;0135;Tafeln;
S;;013;;0137;Elemente;
S;;014;Fassadenpl.speziell;;;
S;;014;;0141;Asphalt;

and the error message 

ERROR:  invalid input syntax for integer: ""
CONTEXT:  COPY warengruppen, line 1, column holder: ""

i know it's hard to fill the integer colume    holder    with nothing out of csv table.. but it's the same with the colume   WarenGruppe so i can't use a char type... so mybe someone know a litte trick to save me ?? don't like to reformat 10MB datasource ...

thank's 

Sebastian
 

view thread (2+ messages)  latest in thread

Message-ID: <000801c42f04$ba09b6f0$0a0010ac@2864id>
Permalink:  ../000801c42f04$ba09b6f0$0a0010ac@2864id/
Also on:    postgresql.org/message-id/000801c42f04$ba09b6f0$0a0010ac@2864id

copy link · copy postgr.es

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: stewes@tewes.homelinux.net
  Subject: Re: invalid input syntax for integer: ""
  In-Reply-To: <000801c42f04$ba09b6f0$0a0010ac@2864id>

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

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