Re: Client-requested cast mode to emulate Pg8.2 on v8.3

From: "Anton Melser" <melser(dot)anton(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Client-requested cast mode to emulate Pg8.2 on v8.3
Date: 2008-03-25 09:46:50
Message-ID: 92d3a4950803250246h73a6de83j3bbc5153f06b36b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Sturm 2008-03-25 09:55:48 Re: Install Postgresql on Win2000 with Admin Rights
Previous Message Magnus Hagander 2008-03-25 09:19:41 Re: Install Postgresql on Win2000 with Admin Rights