Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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