vacuumdb: ERROR: Invalid UNICODE character sequence found

From: Marcello Perathoner <marcello(at)perathoner(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: vacuumdb: ERROR: Invalid UNICODE character sequence found
Date: 2004-06-11 02:24:53
Message-ID: 40C917F5.3030700@perathoner.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-06-11 03:27:10 Re: vacuumdb: ERROR: Invalid UNICODE character sequence found
Previous Message Mark Striebeck 2004-06-11 01:14:32 out of memory error