I’m using a lot of database views to create various lists in my RoR
applications and I’ve problems keeping them updated.
The problem is, that some of my views are depending on some other views.
So I have for example:
View B, depends on View A
View C, depends on View A
If I need to update View A for any reason, I’ve to cascade drop it and
re-create View B & C, because Postgresql (8.2 btw.) doesn’t support
changes to a view very well.
When using rake for database migration, I always have to manually check
for dependencies first. Then, I’ve to re-create the other views. That
isn’t working well.
Is there any good attempt to have something like database-view
migrations with dependencies?