Re: Change definition of a view - Mailing list pgsql-sql

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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: unique constraint instead of primary key? what disadvantage(ODBC usage)?
Next
From: Bryce Nesbitt
Date:
Subject: UNIQUE, btree index allows duplicate records, if some fields are null