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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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