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

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

Предыдущее
От: Massimo Dal Zotto
Дата:
Сообщение: Re: [HACKERS] PostgreSQL 6.5.2
Следующее
От: Keith Parks
Дата:
Сообщение: CVS Broken?