Questions, help!!

From: <barron(at)clubinter(dot)net>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Questions, help!!
Date: 2003-11-08 23:29:30
Message-ID: 34034.216.60.72.45.1068334170.squirrel@clubinter.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

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

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.

Thanks for your help!!

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Aled Morris 2003-11-08 23:34:05 Re: [NOVICE] Help with "locking" please
Previous Message Tom Lane 2003-11-08 23:14:16 Re: Questions, help!!