Re: [HACKERS] Re: Recursive use of syscaches (was: relation ### modified while in use)

2000-11-09 Thread Tom Lane
Hiroshi Inoue <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Why? We are able to construct all the non-nailed relcache entries >> from scratch during backend startup. That seems a sufficient >> proof that we can reconstruct any or all of them on demand. > Hmm,why is it sufficent ? > At backen

Re: [HACKERS] Re: Recursive use of syscaches (was: relation ### modified while in use)

2000-11-09 Thread Hiroshi Inoue
Tom Lane wrote: > Hiroshi Inoue <[EMAIL PROTECTED]> writes: > > My concern is the robustness of rel cache. > > It seems pretty dangerous to discard system relation > > descriptors used for cache mechanism especially in > > case of error recovery. > > It also seems pretty dangerous to recontruct re

[HACKERS] Re: Recursive use of syscaches (was: relation ### modified while in use)

2000-11-09 Thread Tom Lane
Hiroshi Inoue <[EMAIL PROTECTED]> writes: > My concern is the robustness of rel cache. > It seems pretty dangerous to discard system relation > descriptors used for cache mechanism especially in > case of error recovery. > It also seems pretty dangerous to recontruct relation > descriptors especia

[HACKERS] Re: Recursive use of syscaches (was: relation ### modified while in use)

2000-11-09 Thread Hiroshi Inoue
Tom Lane wrote: > "Hiroshi Inoue" <[EMAIL PROTECTED]> writes: > >> Does this occur after a prior error message? I have been suspicious > >> because there isn't a mechanism to clear the syscache-busy flags during > >> xact abort. > > > I don't know if I've seen the cases you pointed out. > > I hav

[HACKERS] Re: Recursive use of syscaches (was: relation ### modified while in use)

2000-11-09 Thread Tom Lane
I wrote: > On top of that, we have the issue I was concerned about that there is > no mechanism for clearing the cache-busy flags during xact abort. Hmm, brain cells must be fading fast. On looking into the code I find that there *is* such a mechanism --- installed by yours truly, only three mon