Change definition of a view

From: Andreas Roth <aroth(at)arsoft-online(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Change definition of a view
Date: 2006-02-09 17:11:24
Message-ID: 200602091811.24476.aroth@arsoft-online.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2006-02-09 17:12:35 Re: unique constraint instead of primary key? what disadvantage(ODBC usage)?
Previous Message BigSmoke 2006-02-09 16:22:59 Re: unique constraint instead of primary key? what disadvantage(ODBC usage)?