Change definition of a view - Mailing list pgsql-sql

From Andreas Roth
Subject Change definition of a view
Date
Msg-id 200602091811.24476.aroth@arsoft-online.com
Whole thread Raw
Responses Re: Change definition of a view  ("Keith Worthington" <keithw@narrowpathinc.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: "BigSmoke"
Date:
Subject: Re: unique constraint instead of primary key? what disadvantage(ODBC usage)?
Next
From: Tom Lane
Date:
Subject: Re: unique constraint instead of primary key? what disadvantage(ODBC usage)?