Re: create or replace view

On Thu, Nov 14, 2002 at 13:41:18 +0000,
snpe <snpe(at)snpe(dot)co(dot)yu> wrote:
> Hello,
> When I change view and change number of column PostgreSQL return error :
> 'cannot change number of column in view'
> Is it too hard set this command
> if view exits drop view
> and then change view
>
> It is like with return type in function
>
> Now 'or replace' don't help too much

The create or replace command exists so that you can modify a view in a
way that allows other objects that refer to it to keep working (without
having to recreate those objects). However if you can the number of
columns (and probably any of their types), then these other objects
or going to need to know that things have changed so that you can't
just replace the view.