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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

On Thu, 9 Feb 2006 18:11:24 +0100, Andreas Roth wrote
> 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

Andreas,

I believe that is exactly what you have to do.

Kind Regards,
Keith

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match