Re: pg_index question

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_index question
Дата
Msg-id 16306.1111793781@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_index question  (Scott Marlowe <smarlowe@g2switchworks.com>)
Ответы Re: pg_index question  (Terry Lee Tucker <terry@esc1.com>)
Список pgsql-general
Scott Marlowe <smarlowe@g2switchworks.com> writes:
> Umm, I tried it and it worked.  Sure you got the right relid?

I think the relation cache will probably not notice a manual update on
pg_index.  So whether it "works" or not would depend on a lot of
extraneous factors like whether the relation cache entry was already
built for the target table and whether you did something else that would
force a cache rebuild.

In any case, the whole idea is so fraught with pitfalls that I couldn't
recommend it ...

            regards, tom lane

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: help w/ a little naive brainstorming ...
Следующее
От: OpenMacNews
Дата:
Сообщение: Re: help w/ a little naive brainstorming ...