Tom Lane wrote:
>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
>
>
I can't see this row, could I select the contents of pg_type into a
table, truncate pg_type and load the table back up?
Thanks for you help.
Michael