Re: bytea and vacuum analyze on postgresql 7.3.4

Lists: pgsql-bugs
From: Michael Radziej <mir(at)suse(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Cc: Reinhard Max <max(at)suse(dot)de>
Subject: bytea and vacuum analyze on postgresql 7.3.4
Date: 2003-09-29 16:50:17
Message-ID: 20030929165017.GF13637@suse.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

Hi,

I hit the following bug:

this is with a 7.3.4 database server (and psql client)
PGCLIENTENCODING="utf-8"
and a utf-8 encoded database,

pensieve=> create table a(raw bytea);
CREATE TABLE
pensieve=> insert into a values('\770\711\056'::bytea);
INSERT 1112630 1
pensieve=> vacuum analyze a;
VACUUM
pensieve=> insert into a values('\770\711\056'::bytea);
INSERT 1112631 1
pensieve=> vacuum analyze a;
ERROR: Invalid UNICODE character sequence found (0xf8c92e)

I think bytea should accept ANY value and vaccuum analyze must
not complain about this.

Is this new to you?

Regards,

Michael

--
=============================================================================
Michael Radziej SuSE Linux AG phone +49-911-74053-0
IT Deutschherrenstr. 15-19 fax +49-911-3206727
(vormals "interne EDV") 90429 Nürnberg, Germany web http://www.suse.de
=============================================================================
Heute schon geändert? -- simply change

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Radziej <mir(at)suse(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org, Reinhard Max <max(at)suse(dot)de>
Subject: Re: bytea and vacuum analyze on postgresql 7.3.4
Date: 2003-10-01 23:33:43
Message-ID: 10745.1065051223@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

Michael Radziej <mir(at)suse(dot)de> writes:
> I think bytea should accept ANY value and vaccuum analyze must
> not complain about this.

This is fixed as of 7.4, I think (at least your example case doesn't
fail for me). 7.3 was a bit sloppy about how it treated entries in
pg_statistic ...

regards, tom lane