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
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 |