On Thursday, July 28, 2011 11:22:44 am Wells Oliver wrote: > Hi folks. On 8.4 here, and I can't solve this tedious thing. I have two > servers. One of them, all the casts are properly configured. I've > pg_dump'ed the DB there, and restored it. And I get tons of errors about > incompatible types. Both servers are 8.4 correct? If so you might want to see potential answer further down. > > For example, a view w/ some UNION statements blows up: > UNION/INTERSECT/EXCEPT could not convert type integer[] to text[] > > But it works fine on the primary server. So I go into pgadmin, then > right-click on Casts, and New Cast. Choose integer[] as the source, text[] > as the target, check Implicit. ERROR: array data types are not binary > compatible. Uncheck Implict, same error. The 'Function' drop-down list is > empty. > > Can anyone help me clear this up? It's a very nagging issue to have my two > servers in a different state.. Deja vu. Per Tom's earlier post: http://archives.postgresql.org/pgsql-general/2011-07/msg00825.php You might to look at this recently discovered bug: http://archives.postgresql.org/message-id/201107270042.22427.julian@xxxxxxxxxx > > -- > Wells Oliver > Architect, Baseball Systems > 619-795-5359 > San Diego Padres | 100 Park Boulevard | San Diego CA 92101 -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
