Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux