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

From G. Anthony Reina
Subject Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog
Date
Msg-id 37CC3913.77F76504@nsi.edu
Whole thread Raw
In response to Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog
List pgsql-hackers
Tom Lane wrote:

> Is it possible that you've got tables lying around that have ordinary-
> circle-type fields in them?

No. No tables at all use the type circle.

> 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?

Thanks.
-Tony




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog
Next
From: Massimo Dal Zotto
Date:
Subject: Re: [HACKERS] PostgreSQL 6.5.2