pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedvacuumdb: ERROR: Invalid UNICODE character sequence found
2+ messages / 2 participants
[nested] [flat]
* vacuumdb: ERROR: Invalid UNICODE character sequence found
@ 2004-06-11 02:24 Marcello Perathoner <marcello@perathoner.de>
2004-06-11 03:27 ` Re: vacuumdb: ERROR: Invalid UNICODE character sequence found Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Marcello Perathoner @ 2004-06-11 02:24 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: vacuumdb: ERROR: Invalid UNICODE character sequence found
2004-06-11 02:24 vacuumdb: ERROR: Invalid UNICODE character sequence found Marcello Perathoner <marcello@perathoner.de>
@ 2004-06-11 03:27 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2004-06-11 03:27 UTC (permalink / raw)
To: Marcello Perathoner <marcello@perathoner.de>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-06-11 03:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-11 02:24 vacuumdb: ERROR: Invalid UNICODE character sequence found Marcello Perathoner <marcello@perathoner.de>
2004-06-11 03:27 ` Re: vacuumdb: ERROR: Invalid UNICODE character sequence found Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox