Re: Continuous inserts...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Continuous inserts...
Дата
Msg-id 13720.966968180@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Continuous inserts...  (Jan Wieck <janwieck@Yahoo.com>)
Ответы Re: Continuous inserts...  (Joerg Hessdoerfer <Joerg.Hessdoerfer@sea-gmbh.com>)
Список pgsql-sql
Jan Wieck <janwieck@Yahoo.com> writes:
>     I haven't looked at the code, but pg_class only has a boolean
>     telling if a class has rules or not. Could it be that  adding
>     more  rules  (or  dropping just a few instead of all) doesn't
>     update the pg_class tuple, thus the syscache  for  the  table
>     isn't  invalidated and other backends continue to use the old
>     information instead of rescanning pg_rewrite?

This is done correctly in current sources --- see
setRelhasrulesInRelation().  However I recall having dorked with that
code not long ago, and I forget what it looked like before.  Perhaps
7.0.* is broken in this respect?  Would think people would have noticed,
though.
        regards, tom lane


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

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: Continuous inserts...
Следующее
От: Joerg Hessdoerfer
Дата:
Сообщение: Re: Continuous inserts...