Mischa Sandberg <[EMAIL PROTECTED]> writes: > Quoting Tom Lane <[EMAIL PROTECTED]>: >> Mischa Sandberg <[EMAIL PROTECTED]> writes: >>> + if (kill(1,0) && errno == ESRCH && >>> PGSharedMemoryIsInUse(0,NextShmemSegID)) >>> + continue; >> >> Isn't the last part of that test backward? If it isn't, I don't >> understand what it's for at all.
> Serious blush here. Yes. Actually, after re-reading what PGSharedMemoryIsInUse does, I don't think you want to use it: it goes to considerable lengths to avoid returning a false positive, whereas in this context I believe we *do* need to avoid segments that belong to other data directories. So you probably need a separate chunk of code that only does the nattch test. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match