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

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog
Дата
Msg-id 37CC8686.DC01B90D@alumni.caltech.edu
обсуждение исходный текст
Ответ на Re: [HACKERS] ERROR: Unable to locate type oid 718 in catalog  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: [HACKERS] File descriptor leakage?
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: [HACKERS] Postgres' lexer