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

BUG #2979: Functional indexes ERROR while updating table

From: "Roman Grigorovich" <mail(at)atz(dot)msk(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2979: Functional indexes ERROR while updating table
Date: 2007-02-07 11:42:37
Message-ID: 200702071142.l17Bgbdl074123@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2979
Logged by:          Roman Grigorovich
Email address:      mail(at)atz(dot)msk(dot)ru
PostgreSQL version: 8.1.7
Operating system:   FreeBSD 5.4-RELEASE
Description:        Functional indexes ERROR while updating table
Details: 

create table test1 (name varchar(64));
create index test1_name_idx on test1(upper(name));
insert into test1 values ('test');
update test1 set name = 'test1';

ERROR:  attribute 1 has wrong type
DETAIL:  Table has type character varying, but query expects character
varying.

What is it? On version 8.1.2 - ALL OK!

Detail of config:
bash-3.00# ./pg_config
BINDIR = /usr/local/postgres/bin
DOCDIR =
INCLUDEDIR = /usr/local/postgres/include
PKGINCLUDEDIR = /usr/local/postgres/include
INCLUDEDIR-SERVER = /usr/local/postgres/include/server
LIBDIR = /usr/local/postgres/lib
PKGLIBDIR = /usr/local/postgres/lib
LOCALEDIR = /usr/local/postgres/share/locale
MANDIR = /usr/local/postgres/man
SHAREDIR = /usr/local/postgres/share
SYSCONFDIR = /usr/local/postgres/etc
PGXS = /usr/local/postgres/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/usr/local/postgres' '--without-docdir' '--enable-nls'
'--cache-file=/dev/null' 'CPPFLAGS=-I/usr/local/include'
'LDFLAGS=-L/usr/local/lib'
CC = gcc
CPPFLAGS = -I/usr/local/include
CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline
-Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing
CFLAGS_SL = -fPIC -DPIC
LDFLAGS = -L/usr/local/lib -Wl,-R/usr/local/postgres/lib
LDFLAGS_SL =
LIBS = -lpgport -lintl -lz -lreadline -lcrypt -lcompat -lm -lutil
VERSION = PostgreSQL 8.1.7

Cluster info:
LC_COLLATE: ru_RU.UTF-8
LC_CTYPE: ru_RU.UTF-8

Responses

pgsql-bugs by date

Next:From: Marcio A. SeppDate: 2007-02-07 14:51:22
Subject: Possible problem with type bigserial in pg_dump/pg_restore
Previous:From: Peter EisentrautDate: 2007-02-07 10:57:21
Subject: Re: BUG #2977: dow doesn't conform to ISO-8601

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