On Friday 19 December 2008 01:29:06 you wrote:
> Aarni writes:
> > "ERROR: operator does not exist: character varying = integer at
> > character 286 HINT: No operator matches the given name and argument
> > type(s). You might need to add explicit type casts."
> >
> > Quick fix to sql statements
Aarni writes:
> "ERROR: operator does not exist: character varying = integer at character 286
> HINT: No operator matches the given name and argument type(s). You might
> need
> to add explicit type casts."
>
> Quick fix to sql statements eg.
>
> ... WHERE CAST (your_char AS INTEGER) = integ
On Thursday 18 December 2008 12:46:38 Peter Eisentraut wrote:
> 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
The error went away; I updated the admin tool I use (pg lightning admin) and
that seemed to help.
Thanks everyone.
Julius Tuskenis-2 wrote:
>
> Raymond O'Donnell rašė:
>> A lot of previously automatic casts were removed in the 8.3 series -
>> this is possibly one of them.
>>
>> You now need t
Raymond O'Donnell rašė:
A lot of previously automatic casts were removed in the 8.3 series -
this is possibly one of them.
You now need to cast explicitly in such cases, e.g.
select '5'::integer;
Ray.
That is a good advice and a good practice. But the solution usually
takes time. For a q
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 no
On 18/12/2008 05:26, 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
A lot of previously automatic casts were removed in the 8.3 series -
this is poss
On Wed, Dec 17, 2008 at 10:26 PM, 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
What's the schema of the table, and the query that is failing?
--
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 pr
