On Thu, Nov 14, 2002 at 13:41:18 +0000, snpe <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
