Skip site navigation (1) Skip section navigation (2)

8.2.2 regression with indices on user functions, 8.2.1 works

From: Tomas Szepe <szepe(at)pinerecords(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: 8.2.2 regression with indices on user functions, 8.2.1 works
Date: 2007-02-06 09:10:32
Message-ID: 20070206091032.GG4631@louise.pinerecords.com (view raw or flat)
Thread:
Lists: 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(at)pinerecords(dot)com>

Responses

pgsql-bugs by date

Next:From: RulDate: 2007-02-06 09:55:19
Subject: BUG #2972: Upgrading 8.2.1 to 8.2.2 changes port on some commands
Previous:From: Martin PittDate: 2007-02-06 07:52:19
Subject: BUG #2971: 8.1.7/8.2.2 break constraint checking for 'update'

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group