Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog
Date
Msg-id 16662.936135989@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog  ("G. Anthony Reina" <reina@nsi.edu>)
List pgsql-hackers
"G. Anthony Reina" <reina@nsi.edu> writes:
> Tom Lane wrote:
>> In any case, it'd be wise to flush everything in pg_operator and pg_proc
>> that has circle as an argument or result type.  (Does DROP TYPE do that
>> for you?  I bet not...)  There might be other system tables that have
>> references to circle, too.

> I'm not sure what you mean by flush pg_operator and pg_proc. What would the
> command be?

I meant drop all the operators and functions that use circle data.

You could run the oidjoins regression test script to find out which ones
those are ... it should complain about all system table entries that
refer to OID 718.  (If you are mistaken that you have no tables using
circles, you'd find that out, too.)
        regards, tom lane


pgsql-hackers by date:

Previous
From: Massimo Dal Zotto
Date:
Subject: Re: [HACKERS] PostgreSQL 6.5.2
Next
From: Keith Parks
Date:
Subject: CVS Broken?