Many type casts to text have just been downgraded from implicit to
assignment-only in PostgreSQL 8.3devel:
http://archives.postgresql.org/pgsql-committers/2007-06/msg00071.php
"This commit does nothing about the issue that applying the
concatenation operator || to non-text types will now fail, often
with strange error messages due to misinterpreting the operator as
array concatenation. Since it often (not always) worked before,
we should either make it succeed or at least give a more user-friendly
error; but details are still under debate."
For now all of the PostGIS loader regression tests are failing
against 8.3devel with errors like
ERROR: operator does not exist: text || integer
long_xact and kml are also failing:
ERROR: function quote_literal(oid) does not exist
ERROR: function textcat("unknown", integer) does not exist
We should probably use explicit casts in these cases. If nobody
objects or beats me to it I'll put together a patch for the regression
tests sometime this week.
--
Michael Fuhr