postgres catalog files problem

Поиск
Список
Период
Сортировка
От Josh Harrison
Тема postgres catalog files problem
Дата
Msg-id 8d89ea1d0709170535r74dd37b4r1a00e9b7e2e97101@mail.gmail.com
обсуждение исходный текст
Ответы Re: postgres catalog files problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,
I noticed that I have too many records in my pg_ catalog files with the same name. For example
if I give this query, which checks for the triggers that do not have corresponding tables in the pg_class

select * from pg_trigger where tgrelid not in (select relfilenode from pg_class),

I get  set of records like this (omitted some fields)

tgrelid                 tgname                                   tgfoid     tgtype          tgconstrname
629324      RI_ConstraintTrigger_654082              1644       5          payment_fk_id      ...                                                                                                                                
 629324      RI_ConstraintTrigger_654083              1645       17        payment_fk_id    ...
........

That is there are records in my pg_trigger that has no corresponding tgrelid in pg_class. Why is that? Is it okay to manually delete these records from the catalog files?

So Im getting this errorthis error when I try to update some tables
' could not open relation with oid'

Thanks for your help
josh


В списке pgsql-general по дате отправления:

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: count (*)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: postgres catalog files problem