| From: | "Keith Worthington" <keithw(at)narrowpathinc(dot)com> |
|---|---|
| To: | Andreas Roth <aroth(at)arsoft-online(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Change definition of a view |
| Date: | 2006-02-09 18:09:04 |
| Message-ID: | 20060209180801.M15130@narrowpathinc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bryce Nesbitt | 2006-02-09 19:38:35 | UNIQUE, btree index allows duplicate records, if some fields are null |
| Previous Message | Tom Lane | 2006-02-09 17:12:35 | Re: unique constraint instead of primary key? what disadvantage(ODBC usage)? |