vacuumdb: ERROR: Invalid UNICODE character sequence found

[Marcello Perathoner]

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)

[Tom Lane]

Post by Marcello Perathoner
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?
PostgreSQL 7.3.3 on i686-redhat-linux-gnu, compiled by GCC 2.96

Update to 7.4. 7.3 mistakenly assumed that it could use "text" as the
storage type for pg_statistic entries.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly