Re: ERROR: type "temp_gc" already exists

Janning Vygen <vygen@gmx.de> writes:
> i guess the table was dropped but not the corresponding type.
> How can things like this happen?

Corrupted pg_depend table maybe?  You might try REINDEXing pg_depend
to be on the safe side.  Also please look to see if there are any
relevant entries in it (look for objid = the type's OID, or refobjid
= 16562879 which we can see was the table's OID).

> How can i fix it?  Can i just drop the type from pg_type?

If there's no pg_depend entry then DROP TYPE should work.  Otherwise
you might have to resort to manually DELETEing the pg_type row.

            regards, tom lane