Tom Lane wrote:
>
> Jan Wieck <JanWieck@Yahoo.com> writes:
>
> What everyone else is telling you is that we should strive to do the
> same, not punt and make the user tell us when to recompile.
>
In Oracle, objects like views, functions and triggers are
just marked INVALID when an object to which they make
reference is changed. INVALID objects are recompiled when
they are needed. in particular, if a table was dropped and
a table is created with the same name then the objects which
make reference (directly/indirectly) to the table would
revive.
We would have to reconsider *alter table .. rename ..* ..
regards,
Hiroshi Inoue