Hello,
one question: Is it possible to add or remove a column from a view without
drop the view and recreate it?
If one or more rules depend on a view, it's very hard to extend a view.
I use the following procedure to extend a view:
- drop depending rules
- drop view
- recreate view with additional column
- recreate all rules
Any help is welcomed!
Thanks,
Andreas Roth