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

From: "G(dot) Anthony Reina" <reina(at)nsi(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog
Date: 1999-08-31 22:13:34
Message-ID: 37CC538E.5D3763C@nsi.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

> 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

So I think you are saying that although none of my tables have the circle type,
there are inherent Postgres functions and
operators which use circle. By running the regression test, I could find out
which functions and operators these are and just drop them. Is the vacuum
crapping out then because it is trying to vacuum one of these functions and
finding that OID 718 doesn't exist?

Thanks.
-Tony

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message G. Anthony Reina 1999-08-31 22:26:05 OID 718 and Circle
Previous Message Tom Lane 1999-08-31 21:52:50 Re: [HACKERS] PostgreSQL 6.5.2