Re: View's plan not taking advantage of WHERE?

Поиск
Список
Период
Сортировка
От Mike Summers
Тема Re: View's plan not taking advantage of WHERE?
Дата
Msg-id CAJGeMG8_-TE7wt1ff9eiUvcsaRG2aF2-wvvjkkvwxzCP_KZE9A@mail.gmail.com
обсуждение исходный текст
Ответ на View's plan not taking advantage of WHERE?  (Mike Summers <msummers57@gmail.com>)
Ответы Re: View's plan not taking advantage of WHERE?  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
It appears that the culprit is a cached query plan, the tables in the UNION have changed and no long match however the View does not throw a "each UNION query must have the same number of columns" error.

Is there a way to force the View's query plan to be updated on each access?

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

Предыдущее
От: Raymond O'Donnell
Дата:
Сообщение: Re: How to modify dump files created by pg_dump
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: View's plan not taking advantage of WHERE?