From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5944: COPY FROM doesn't work with international characters |
Date: | 2011-09-06 16:48:55 |
Message-ID: | 201109061648.p86GmtH04943@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Josh Berkus wrote:
> I have another example of this issue with WIN1252. This line in a copy
> file:
>
> 659446 828 1 /6???\bH(at)^W^Za$H???\b???@\\/ <p><p></p><p>No
> valid or unique HTTP objects found in XML response.</p></p>
>
> Into this table:
>
> Table "public.ep_tests"
> Column | Type | Modifiers
> ---------+--------------+-----------
> id | bigint | not null
> v_id | integer | not null
> status | character(1) | not null
> vkey | text |
> details | text |
>
> Results in this error while loading the data:
>
> the following error is encounted by the \copy: ERROR: missing data for
> column "details"
> CONTEXT: COPY ep_tests, line 1028752: "659446 828 1 /6???\bH(at)?"
>
> The dump file was produced by using 9.0.3's pg_dump in text mode to dump
> an 8.2 database, then using 9.0.3's psql to load the file. Both servers
> are UTF8, locale WIN1252.
>
> So it looks like we're not successfully escaping characters on WIN1252.
> The characters in question are also latin characters.
>
> We've reproduced this on a clean install.
Has this been fixed?
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
From | Date | Subject | |
---|---|---|---|
Next Message | Hadmut Danisch | 2011-09-06 17:07:29 | Re: BUG #6199: Can't install datatype hstore |
Previous Message | Denish Patel | 2011-09-06 16:31:58 | Re: psql doesn't reuse -p after backend fail |