Re: Client-requested cast mode to emulate Pg8.2 on v8.3 - Mailing list pgsql-general

From Anton Melser
Subject Re: Client-requested cast mode to emulate Pg8.2 on v8.3
Date
Msg-id 92d3a4950803250246h73a6de83j3bbc5153f06b36b@mail.gmail.com
Whole thread Raw
In response to Re: Client-requested cast mode to emulate Pg8.2 on v8.3  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Client-requested cast mode to emulate Pg8.2 on v8.3  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> > Anyway, maybe I spoke too soon :-(.
>
>  > ERROR: operator is not unique: integer || unknown
>
>  > I did, of course, not follow the instructions and just blinding
>  > applied them all, but from reading them it doesn't look like the issue
>  > here. Does this error mean there are too many operators or not enough?
>
>
> Too many.  You might have to remove the anynonarray || text and
>  text || anynonarray operators if you're going to continue to rely
>  on implicit casts to text.

Thanks for that. Any chance someone could give me more newbie instructions? :-)
I suppose you are talking about
anytextcat(anynonarray, text)
and
textanycat(text, anynonarray)
But I can't see anywhere obvious where I can "deactivate" them... I
looked for likely suspects in pg_operator, pg_cast... but I'm not
really sure what I'm doing.
Anyone?
Thanks heaps.
Anton

pgsql-general by date:

Previous
From: Tomasz Ostrowski
Date:
Subject: Re: Running function automatically on (unclean) disconnect
Next
From: Stefan Sturm
Date:
Subject: Re: Install Postgresql on Win2000 with Admin Rights