Re: Questions, help!! - Mailing list pgsql-novice

From Bruce Momjian
Subject Re: Questions, help!!
Date
Msg-id 200311090231.hA92Ve901912@candle.pha.pa.us
Whole thread Raw
In response to Questions, help!!  (<barron@clubinter.net>)
List pgsql-novice
barron@clubinter.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-novice by date:

Previous
From: Aled Morris
Date:
Subject: Re: Help with "locking" please
Next
From:
Date:
Subject: Re: error while executing a c program with embedded sql