Skip site navigation (1) Skip section navigation (2)

Re: BUG #5944: COPY FROM doesn't work with international characters

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 (view raw or flat)
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. +

In response to

Responses

pgsql-bugs by date

Next:From: Hadmut DanischDate: 2011-09-06 17:07:29
Subject: Re: BUG #6199: Can't install datatype hstore
Previous:From: Denish PatelDate: 2011-09-06 16:31:58
Subject: Re: psql doesn't reuse -p after backend fail

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group