Re: [HACKERS] COPY from file - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] COPY from file
Date
Msg-id Pine.LNX.4.21.0002090041360.350-100000@localhost.localdomain
Whole thread Raw
In response to COPY from file  (Ole Gjerde <gjerde@icebox.org>)
Responses Re: [HACKERS] COPY from file
List pgsql-hackers
On 2000-02-08, Ole Gjerde mentioned:

> I have a tab delimited file(It's actually just a dump) that includes
> some non-normal ascii characters, the one in question being y with 2 dots.
> If the data has ANY of those in a char(or vchar) field the COPY finishes
> successfully with no errors, but the table is empty.  If I edit
> the data file and remove that y(there was only one), it works just fine.

Fixed it. Thanks for the report, we'd never have found that one.


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Ordering of pg_dump output
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] COPY from file