inserting a column into a view - Mailing list pgsql-novice

From Richard Terry
Subject inserting a column into a view
Date
Msg-id 4FD7BEBE.8070405@internode.on.net
Whole thread Raw
Responses Re: inserting a column into a view
List pgsql-novice
When you modify a table some time down the track and insert a new
column, then need to update a view,  postgres always seems to insist
that you cascade drop all dependant views and rebuild them. I've got a
huge database and find I'm in this situation some years down the track
from its inceptions.

I wondered if there was any clever way around this tedious work?

Thanks in anticipation.

Regards

richard


pgsql-novice by date:

Previous
From: Steve Crawford
Date:
Subject: Re: select from multiple tables
Next
From: Tom Lane
Date:
Subject: Re: inserting a column into a view