Migrating from Sybase - Mailing list pgsql-general

From Jens P. Elsner
Subject Migrating from Sybase
Date
Msg-id 20000723213637.A480@ice.anydomain
Whole thread Raw
Responses Re: Migrating from Sybase  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

I ran into some trouble moving my data from a Sybase ADA db to Postgresql.
I fixed most of the problems (to move the data I unloaded the db and edited
the scripts), but there's one I'm stuck with:

The command:

COPY probe FROM '/home/ice/felsdb/186.dat' using delimiters '|' with null as '' ;

produces

": can't parse "elsdb/import3.sql:419: ERROR:  copy: line 1, pg_atoi: error in "":

The stuff in 186.dat:

WI-02.06.99-029|1999-06-02 11:04:13.184|Werk 1 Mue|KStK00-32/1|Mineralgemisch 0-30mm|||Halde B2, neue Anlage|1999-05-31
10:53:00.000|9922|1999-06-02||WP_B2||Manschke|3|1|A0170938384B|^M 

[....]

The DB table "probe":

CREATE TABLE "probe"^M
(^M
        "probennummer"                  char(20) NOT NULL,^M
        "eingang_am"                    timestamp NOT NULL,^M
        "kunden_nr"                     char(20) NULL,^M
        "produktgruppe"                 char(20) NOT NULL,^M
        "beschreibung"                  varchar(40) NULL,^M
        "chargen_nr"                    varchar(20) NULL,^M
        "lieferschein_nr"               varchar(20) NULL,^M
        "entnahmeort"                   varchar(40) NULL,^M
        "entnommen_am"                  timestamp NULL,^M
        "kalenderwoche"                 integer NULL,^M
        "ankunft_am"                    date NULL,^M
        "fertig_am"                     timestamp NULL,^M
        "jobname"                       char(20) NULL,^M
        "vermerk"                       varchar(40) NULL,^M
        "registriert_von"               varchar(25) NULL,^M
        "type"                          smallint NOT NULL,^M
        "status"                        smallint NOT NULL,^M
        "barcode"                       char(12) NULL,^M
        "mark"                          smallint NULL,^M
        PRIMARY KEY ("probennummer", "eingang_am")^M
);

What am I doing wrong here?

JP

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: failed Delete after Insert in a transaction
Next
From: Bill Barnes
Date:
Subject: RE: Migrating from Sybase