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.
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2012-06-12 22:44:48|
|Subject: Re: inserting a column into a view|
|Previous:||From: Steve Crawford||Date: 2012-06-12 20:04:03|
|Subject: Re: select from multiple tables|