Updating a view - Mailing list pgsql-general

From Patrick Hatcher
Subject Updating a view
Date
Msg-id OF1C4A8764.2975618F-ON88256CFC.007C793C-88256CFC.007EB42E@fds.com
Whole thread Raw
List pgsql-general
Pg 7.3.2

I find that I need to add a column to a view that is used in about 6 other
views.  Please tell me there's a way of changing this base view without
having to drop the six other views and whatever other views those views
might touch.
Using Create or Replace gives me a message that I cannot change the number
of columns in a view.
TIA
Patrick


pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: date format
Next
From: Dennis Gearon
Date:
Subject: Re: ERROR: UNIQUE constraint ... not found?