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