Re: ResetSystemCaches(was Re: [HACKERS] relation ### modified while in use)

[Hiroshi Inoue]

Tom Lane wrote: > Hiroshi Inoue <[EMAIL PROTECTED]> writes: > > RelationCacheInvalidate() is called from ResetSystemCaches() > > and calles RelationFlushRelation() for all relation descriptors > > except some nailed system relations. > > I'm wondering why nailed relations could be exceptions. > > Conversely why must RelationCacheInvalidate() call > > RelationFlushRelation() for other system relations ? > > Isn't it sufficient to call smgrclose() and replace rd_rel > > member of system relations by the latest ones instead > > of calling RelationFlushRelation() ? > > Possibly you could do fixrdesc() instead of just ignoring the report > entirely for nailed-in relations. Not sure it's worth worrying about > though --- in practice, what is this going to make possible? You can't > change the structure of a nailed-in system catalog, nor will adding > triggers or rules to it work very well, so I'm not quite seeing the > point. > Hmm,my point is on not nailed system relations(indexes) not on already nailed relations. Coundn't we skip system relations(indexes) in Relation CacheInvalidate() ? Regards. Hiroshi Inoue