Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuumdb: ERROR: Invalid UNICODE character sequence found - Mailing list pgsql-admin

From Tom Lane
Subject Re: vacuumdb: ERROR: Invalid UNICODE character sequence found
Date
Msg-id 18465.1086924430@sss.pgh.pa.us
Whole thread Raw
In response to vacuumdb: ERROR: Invalid UNICODE character sequence found  (Marcello Perathoner <marcello@perathoner.de>)
List pgsql-admin
Tree view 
Marcello Perathoner <marcello@perathoner.de> writes:
> 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

pgsql-admin by date:

Previous
From: Marcello Perathoner
Date:
Subject: vacuumdb: ERROR: Invalid UNICODE character sequence found
Next
From: akuppachi@hss.hns.com
Date:
Subject: Re: Calculating size of the database tables