Skip site navigation (1) Skip section navigation (2)

inserting a column into a view

From: Richard Terry <rterry(at)internode(dot)on(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: inserting a column into a view
Date: 2012-06-12 22:12:14
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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.




pgsql-novice by date

Next:From: Tom LaneDate: 2012-06-12 22:44:48
Subject: Re: inserting a column into a view
Previous:From: Steve CrawfordDate: 2012-06-12 20:04:03
Subject: Re: select from multiple tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group