Re: Alter Table Column Datatype

Tom Lane <tgl@sss.pgh.pa.us> writes:

> Not sure to what extent we can apply that theory to views, though.
> If it would result in a change in a view's output column datatype,
> do we want to allow that (which would mean recursively propagating
> that column type change to yet other places)?

Just as a datapoint: In oracle I think this is one of the things that cause
the views become invalid and need to be "recompiled". I always found that to
be *extremely* annoying. It would be much nicer if they automatically did the
right thing.

-- 
greg