Michael Guerin <guerin@rentec.com> writes:
>> Does it help if you REINDEX pg_type?
>>
> I will try. The last time this happened I re-indexed all the system &
> user tables, clustered the users tables as well as re-created all the
> user defined types & functions. These steps didn't resolve the problem.
In that case REINDEX probably won't help. You could manually delete the
conflicting pg_type row I suppose.
regards, tom lane