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

Re: BUG #2979: Functional indexes ERROR while updating table

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: "Roman Grigorovich" <mail(at)atz(dot)msk(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2979: Functional indexes ERROR while updating table
Date: 2007-02-08 16:37:16
Message-ID: 1d4e0c10702080837y5e5bec9cu8ce96ac8537472b0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Roman,

On 2/7/07, Roman Grigorovich <mail(at)atz(dot)msk(dot)ru> wrote:
> 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!

This is a known problem of 8.1.7. That's why 8.1.8 has been released.

So you should upgrade to 8.1.8 to fix your problem.

--
Guillaume

In response to

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2007-02-08 16:43:44
Subject: Re: BUG #2980: check constraint fails on update
Previous:From: Tom LaneDate: 2007-02-08 15:37:39
Subject: Re: server crash: displaying sqlerrm in exception block

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