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@xxxxxxxxxx http://tplus1.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
