| 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: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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 | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-09-29 18:53:19 | Re: bug in clusterdb script |
| Previous Message | Bertrand Petit | 2003-09-28 02:26:13 | Re: PG 7.4 BETA 3: Bug in NULL arrays updating |