8.2.2 regression with indices on user functions, 8.2.1 works
От | Tomas Szepe |
---|---|
Тема | 8.2.2 regression with indices on user functions, 8.2.1 works |
Дата | |
Msg-id | 20070206091032.GG4631@louise.pinerecords.com обсуждение исходный текст |
Ответы |
Re: 8.2.2 regression with indices on user functions, 8.2.1 works
|
Список | pgsql-bugs |
Hi, Upgraded to 8.2.2 last night and had to revert to 8.2.1 first thing in the morning after hitting this problem: A trivial update like update mwdev set nick='Bezno-V-360'; fails with ERROR: attribute 1 has wrong type DETAIL: Table has type character varying, but query expects character varying. There are no further messages in server.log. A minimal testcase to replicate the problem follows: $ createdb -E UNICODE testdb CREATE DATABASE $ (cat| psql testdb) << EOF CREATE FUNCTION e_tolower(text) RETURNS text AS \$_\$select translate(\$1, 'Q', 'q');\$_\$ LANGUAGE sql IMMUTABLE; CREATE TABLE testtbl (foo character varying(16) NOT NULL); COPY testtbl (foo) FROM stdin; whatever \. CREATE UNIQUE INDEX testtbl_testidx ON testtbl USING btree (e_tolower((foo)::text)); UPDATE testtbl SET foo='whatever2'; EOF CREATE FUNCTION CREATE TABLE CREATE INDEX ERROR: attribute 1 has wrong type DETAIL: Table has type character varying, but query expects character varying. $ Just putting back the old 8.2.1 binaries is enough (the problem disappears), no need to redump/reinitdb. System: Linux 2.6.20, x86, glibc 2.5, gcc 4.1.1. Hope this helps, -- Tomas Szepe <szepe@pinerecords.com>
В списке pgsql-bugs по дате отправления: