Materializing a view by hand

Поиск
Список
Период
Сортировка
От Robert James
Тема Materializing a view by hand
Дата
Msg-id CAGYyBgj7W7y5rfbBYjnRKuZYUsfmNXzR0irFZefzNt5vxx-ocA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Materializing a view by hand  (Kevin Grittner <kgrittn@ymail.com>)
Re: Materializing a view by hand  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
I have a view which is very slow to computer, but doesn't change often.

I'd like to materialize it. I thought I'd do a simple poor man's materialize by:

1) ALTER VIEW myview RENAME to _myview
2) SELECT * INTO myview FROM _myview

The only problem is that all my other views, which are dependent on
myview, automatically rename to _myview.  That would normally be very
helpful but is exactly the opposite of what I want!

Is there a work around?

 I'm running Postgres 8.3 - upgrading is a possibility but difficult.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: View permission error after upgrading from 8.4 -> 9.2
Следующее
От: Robert James
Дата:
Сообщение: What type of index do I need for this JOIN?