Re: ALTER TABLE should change respective views - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ALTER TABLE should change respective views
Date
Msg-id 22431.1241548293@sss.pgh.pa.us
Whole thread Raw
In response to Re: ALTER TABLE should change respective views  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> Incompatible table changes would still require manual drop and 
> recreation, of course.  But most table changes to a production database 
> are adding fields or changing constraints, which in most cases won't 
> break dependant views or functions.

... as indeed they don't.  What's your point?  The question here was
about whether the DB should try to guess the right behavior for a
datatype change in an existing column.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: community equipment
Next
From: Peter Eisentraut
Date:
Subject: Re: Unicode string literals versus the world