How to intelligently work with views that depend on other views

Поиск
Список
Период
Сортировка
От W. Matthew Wilson
Тема How to intelligently work with views that depend on other views
Дата
Msg-id CAGHfCUCwbY3RtOWxWa7mJJ7ubTio_iqY3bEATDrGXOSr4HHppg@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to intelligently work with views that depend on other views
Re: How to intelligently work with views that depend on other views
Список pgsql-general
I have a bunch of views, and some views use data from other views.

For example, view A might get used by view B and view B gets used by view C.

Several times now, as I got further into the project, I've changed how
I make some views and I've had to redefine not just that view, but all
the ones that depend on it.

This is getting frustrating!  When I want to change how I make view A,
I have to drop view A cascade, and then view B and view C are dropped.

Then I have to remember to re-create B and C after I rewrite A.

There's likely a better solution...

What is it?

GO POSTGRESQL!


--
W. Matthew Wilson
matt@tplus1.com
http://tplus1.com


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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: multiple postgres processes after establishing tcp connection
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: How to intelligently work with views that depend on other views