Re: Strange error related to temporary tables

Csaba Nagy <nagy@ecircle-ag.com> writes:
> I executed what you suggest below, see the results below. Short
> conclusion: the type is there in pg_type, the relation is not there in
> pg_class. Is there anything I should look for more ?

> test03=> select oid, xmin from pg_type where typname = 'temp_report';
>    oid    |   xmin
> ----------+-----------
>  58293995 | 220215039
> (1 row)

Is this xmin quite a bit older than what you get for a freshly-created
temp table?  Can you find any entries in pg_depend that show the above
OID as either objid or refobjid?

Also, it's fairly likely (not certain) that the table associated with
this pg_type entry had OID one less, ie 58293994.  Can you find any
trace of that OID in pg_depend, or in pg_class for that matter?

            regards, tom lane