Re: Alter Table Column Datatype - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Alter Table Column Datatype
Date
Msg-id 87fzife9kx.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: Alter Table Column Datatype  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)
Next
From: Tom Lane
Date:
Subject: Re: Alter Table Column Datatype