X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BB2463A49DE for ; Mon, 15 Nov 2004 20:29:56 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39127-02 for ; Mon, 15 Nov 2004 20:29:46 +0000 (GMT) Received: from leda.steelsun.com (dsl093-240-204.ral1.dsl.speakeasy.net [66.93.240.204]) by svr1.postgresql.org (Postfix) with ESMTP id 2A2223A47E6 for ; Mon, 15 Nov 2004 20:29:46 +0000 (GMT) Received: from leda.steelsun.com (localhost [127.0.0.1]) by leda.steelsun.com (8.12.11/8.12.8) with ESMTP id iAFKTcpL012994; Mon, 15 Nov 2004 15:29:38 -0500 Received: from localhost (cfowler@localhost) by leda.steelsun.com (8.12.11/8.12.11/Submit) with ESMTP id iAFKTc4t012991; Mon, 15 Nov 2004 15:29:38 -0500 X-Authentication-Warning: leda.steelsun.com: cfowler owned process doing -bs Date: Mon, 15 Nov 2004 15:29:38 -0500 (EST) From: Christian Fowler X-X-Sender: cfowler@leda.steelsun.com To: Tom Lane Cc: Christian Fowler , pgsql-admin list Subject: Re: evil characters #bfef cause dump failure In-Reply-To: <9996.1100547889@sss.pgh.pa.us> Message-ID: References: <9996.1100547889@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/119 X-Sequence-Number: 15503 [shell]$ env PGCLIENTENCODING=UNICODE LANG=en_US.UTF-8 db=# \encoding UNICODE On Mon, 15 Nov 2004, Tom Lane wrote: > Christian Fowler writes: >> After much wrestling, it appears the hex byte sequence #bfef in a VARCHAR >> column causes a truncated COPY line to be written (and thus the *entire* >> COPY block fails). > > What database encoding and locale are you using? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > [ \ / [ >X< Christian Fowler | spider AT viovio.com [ / \ http://www.viovio.com | http://www.tikipro.org