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!!
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!! |