Re: Questions, help!!

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: barron(at)clubinter(dot)net
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Questions, help!!
Date: 2003-11-09 02:31:40
Message-ID: 200311090231.hA92Ve901912@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

barron(at)clubinter(dot)net wrote:
> 1.ERROR: line 1, "Bad date external representation" when executing copy
> cliente from '/home/txtfiles/cliente.asc' with delimiter as '|'.
>
> a. RH Linux 9.0
> b. PostgreSQL 7.3
> c. Importing text file from SQL informix Online 5.0
> d. Configured datestyle: "ISO with US (NonEuropean) conventions

Please show us the date value on line 1.

> 2. ERROR: copy: line 1, "Extra data after last expected column" when
> executing copy maxtrn from '/home/txtfiles/maxtrn.asc' with delimiter as
> '|'

Yes, this is a known problem. Informix puts the delimiter at the end of
the line, while we don't. You have to strip them, perhap with sed:

sed 's/|$//' file

> a. The text file "maxtrn.asc" was generated by Informix Online 5.0, and
> its structure is:
> 5|02|C|286|
> 5|40|C|287|
> b. The table "maxtrn" has columns:
> cvesuc int2
> cuenta char(2)
> cvetrn char(1)
> folio int4
>
> 3. I cannot connect to PostgreSQL database from Kylix 3. I got the error
> message "DbExpress Error: Invalid username/password"
>
> a. I'm trying to connect with the account "postgres" which was generated
> by RH Linux 9.0 and I verified entrance to the account with the password I
> assigned to it previously.

Not sure on that one. Perhaps it is using an older PostgreSQL client
library and you have to use 'password' or 'crypt' rather than 'md5'.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Philip Riggs 2003-11-09 03:35:02 The data directory was initialized by PostgreSQL version 7.4, which is not compatible with this version 7.3.3.
Previous Message Aled Morris 2003-11-08 23:34:05 Re: [NOVICE] Help with "locking" please