Re: Questions, help!!

<barron(at)clubinter(dot)net> writes:
> 1.ERROR: line 1, "Bad date external representation" when executing copy
> cliente from '/home/txtfiles/cliente.asc' with delimiter as '|'.

Can't help you on that without seeing the data it's objecting to.

> 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

COPY thinks that these data lines have five columns, with the fifth being
empty. You can either get rid of the trailing "|" characters (a quick
sed script would do it), or you can make COPY happy by providing a fifth
column to import into. For instance,

ALTER TABLE maxtrn ADD COLUMN junk text;
... COPY ...
ALTER TABLE maxtrn DROP COLUMN junk;

> 3. I cannot connect to PostgreSQL database from Kylix 3. I got the error
> message "DbExpress Error: Invalid username/password"

Sorry, dunno anything about Kylix. If you can show us the message that
shows up in the postmaster's log (postmaster stderr output) when you try
to connect, maybe we could help.

regards, tom lane