Forum OpenACS Q&A: Re: PG 7.2->7.3 upgrade gotcha?

Collapse
Posted by Richard Hamilton on
Following the upgrade I am getting lots of these in the error logs when testing both forums and photo album:

[22/Mar/2004:23:50:49][8221.49156][-conn0-] Error: Ns_PgExec: result status: 7 message: ERROR:  operator is not unique: bit varying || "unknown"
HINT:  Could not choose a best candidate operator. You may need to add explicit type casts.
CONTEXT:  PL/pgSQL function "tree_left" line 11 at return

I am guessing that they have to do with the change in trigger return type from "opaque" to "trigger" but I have absolutely no idea how to add explicit casts to functions and I am not even sure what data type to cast.

Oh bother.