From: Andreas Roth <aroth@arsoft-online.com>
To: pgsql-sql@postgresql.org
Subject: Change definition of a view
Date: Thu, 9 Feb 2006 18:11:24 +0100
Message-ID: <200602091811.24476.aroth@arsoft-online.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: aroth@arsoft-online.com
Subject: Re: Change definition of a view
In-Reply-To: <200602091811.24476.aroth@arsoft-online.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox