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

From Thomas Lockhart
Subject Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog
Date
Msg-id 37CC8686.DC01B90D@alumni.caltech.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>)
List pgsql-hackers
> > I meant drop all the operators and functions that use circle data.
> 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?

Aren't the built-in types cached at compile time? Even if not, I'd
*really* suggest using a different name for your table. Even "Circle"
(including the double-quotes and mixed case) would work, and would
keep you from having to drop built-in types.
                      - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: [HACKERS] File descriptor leakage?
Next
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] Postgres' lexer