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 04895D1B1C9 for ; Thu, 10 Jun 2004 23:23:33 -0300 (ADT) 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 61804-04 for ; Fri, 11 Jun 2004 02:23:28 +0000 (GMT) Received: from perathoner.de (perathoner.de [213.133.103.166]) by svr1.postgresql.org (Postfix) with SMTP id A187FD1B191 for ; Thu, 10 Jun 2004 23:23:22 -0300 (ADT) Received: (qmail 4378 invoked from network); 11 Jun 2004 02:23:25 -0000 Received: from unknown (HELO perathoner.de) (127.0.0.1) by localhost with SMTP; 11 Jun 2004 02:23:25 -0000 Message-ID: <40C917F5.3030700@perathoner.de> Date: Fri, 11 Jun 2004 04:24:53 +0200 From: Marcello Perathoner User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040413 Debian/1.6-5 X-Accept-Language: en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: vacuumdb: ERROR: Invalid UNICODE character sequence found Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit 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: 200406/142 X-Sequence-Number: 13802 I get this error when I try to analyze a column containing md5 hashes. The data type of the column is: bytea. The database encoding is UNICODE. Does anybody know a workaround for this? Thanks. $ vacuumdb --analyze --table 'files(md5hash)' ERROR: Invalid UNICODE character sequence found (0xdb51) vacuumdb: vacuum files(md5hash) gutenberg failed $ psql --version psql (PostgreSQL) 7.3.3 contains support for command-line editing gutenberg=> SELECT version(); version ----------------------------------------------------------------- PostgreSQL 7.3.3 on i686-redhat-linux-gnu, compiled by GCC 2.96 (1 row) -- Marcello Perathoner