pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
vacuumdb: 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