Re: DB Crash, recoverable?

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