Ok, I've been using postgres for a-while now, and am curious how you
guys handle this. What is the best way to make modifications to
tables that have lots of dependent objects, like views? Do you just
do the obvious drop...cascade and manually re-create your views? Do
you keep your "create view" statements in a text file for this purpose
or just pull them from a pg_dump file? Is there a better way to
handle this sort of thing?
I know on a properly designed database, changes to the schema are
usually not necessary. However, during development, database tweaks
(at least for me) are pretty common.
Any thoughts?