Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog

"G. Anthony Reina" <reina@nsi.edu> writes:
> Anyone run into this error before:
> ERROR:  Unable to locate type oid 718 in catalog
> This occurred when I tried to 'vacuum verbose analyze' my database.

A quick glimpse says that the only occurrences of that error text are
in parse_type.c, which is not code that I'd think would get called from
vacuum.  Odd.

If you do "select * from pg_type where oid = 718;" you should get

typname|typowner|typlen|typprtlen|typbyval|typtype|typisdefined|typdelim|typrelid|typelem|typinput |typoutput
|typreceive|typsend  |typalign|typdefault
 

-------+--------+------+---------+--------+-------+------------+--------+--------+-------+---------+----------+----------+----------+--------+----------
circle |     256|    24|       47|f       |b      |t           |,       |       0|
0|circle_in|circle_out|circle_in|circle_out|d       |
 
(1 row)

If you don't then indeed pg_type is corrupted.
        regards, tom lane