I'm in the depths of a CAST nightmare and I can't work my out

Поиск
Список
Период
Сортировка
От Wells Oliver
Тема I'm in the depths of a CAST nightmare and I can't work my out
Дата
Msg-id 4003120D-06A0-4163-9CA6-A5CA216B6EFE@padres.com
обсуждение исходный текст
Ответы Re: I'm in the depths of a CAST nightmare and I can't work my out  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
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
properlyconfigured. I've pg_dump'ed the DB there, and restored it. And I get tons of errors about incompatible types. 

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.
UncheckImplict, 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..

--
Wells Oliver
Architect, Baseball Systems
619-795-5359
San Diego Padres | 100 Park Boulevard | San Diego CA 92101


В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Nolan
Дата:
Сообщение: Re: using xmin in a query?
Следующее
От: Rodrigo Gonzalez
Дата:
Сообщение: Re: using xmin in a query?