Re: Error: Operator does not exist: "char"=integer - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Error: Operator does not exist: "char"=integer
Date
Msg-id 494A2A0E.7020004@gmx.net
Whole thread Raw
In response to Error: Operator does not exist: "char"=integer  (novnov <novnovice@gmail.com>)
Responses Re: Error: Operator does not exist: "char"=integer  (Aarni <aarni@kymi.com>)
List pgsql-general
novnov wrote:
> I have restored a postgres 8.2.4-1 db onto a postgres 8.3.1-1 server, and
> when I try to work with a table I get this error:
>
> Error: Operator does not exist: "char" = integer
>
> Hopefully that is enough of a clue to be useful. Maybe this is the first
> time I've tried moving one of my non-trivial pg projects to a significantly
> different version of postgres; is there a conversion process that helps with
> moving between versions?

Yes, reading the release notes. ;-)  I think you will find your problem
explained there.

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Other queries locked out during long insert
Next
From: Rainer Bauer
Date:
Subject: Missing usenet messages. Was: A bit confused about Postgres Plus