Re: [HACKERS] fatal copy in/out error (6.5.3) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] fatal copy in/out error (6.5.3)
Date
Msg-id 25300.948730015@sss.pgh.pa.us
Whole thread Raw
In response to fatal copy in/out error (6.5.3)  (Michael Robinson <robinson@netrinsics.com>)
Responses Re: [HACKERS] fatal copy in/out error (6.5.3)
List pgsql-hackers
Michael Robinson <robinson@netrinsics.com> writes:
>     testdb=> create table foo (word varchar(30));
>     CREATE
>     testdb=> insert into foo values ('\217\210');
>     INSERT 2337289 1
>     testdb=> copy "foo" to '/usr/local/pgsql/foo.out';
>     COPY
>     testdb=> \q
>     % od -c foo.out
>     0000000  217 210  \0  \n                                                
>     0000004

Hmm.  I get0000000 217 210  \n0000003
with either current sources or 6.5.3.  I don't have MULTIBYTE nor
USE_LOCALE turned on, though.  What is your configuration exactly?

This looks to me like something is deciding that \217 must be the
start of a 3-byte multibyte character... in which case, it should have
appeared that way in your database, I think.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] Re: Status on 7.0
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] column aliases