Tom Lane wrote: > > Jan Wieck <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
