"Dhanaraj M" <[EMAIL PROTECTED]> wrote > > 2. *Invalidate prepared queries, like INSERT, when the table > definition is altered > > *Invalidation means recompilation or deletion of the prepared stmt > here.* > *Both the items look similar. i.e) needs recompilation of the query > after altering the table. > It is right?* > *
Yes, IMHO the basic idea is like that - the difficulty is that we are lack of efficient object tracking mechanism, so that when an underlying object is changed, all the prepared plans should be invalidated. Regards, Qingqing ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster