I'm in the process of attempting to upgrade from 8.1 to 8.4, and I've been
using the uniqueidentifier contrib module for my UUID's ... In 8.1 Postgresql
was able to figure out what to do with statements like
# SELECT 'Your new UUID is ' || newid();
?column?
-------------------------------------------------------
Your new UUID is 5f1a4987-9005-42d6-8e62-d1ff14bb1433
(1 row)
but in 8.4 (and probably 8.3 also...),
# SELECT 'Your new UUID is ' || newid();
ERROR: operator is not unique: unknown || uniqueidentifier
LINE 1: SELECT 'Your new UUID is ' || newid();
^
HINT: Could not choose a best candidate operator. You might need to add
explicit type casts.
But, with the new internal UUID datatype, what is the magic recipe that allows
this to run?
# SELECT 'Your new UUID is ' || uuid_generate_v4();
?column?
-------------------------------------------------------
Your new UUID is cd8d8f5f-3eea-4e96-be4f-f93daa174d8f
(1 row)
I could add the explicit type casts, but I'd rather find out what the nature of
the subtle (or not-so-subtle) difference I've stumbled upon is...
