Thread: ExecRestrPos: node type 18 not supported
I'm getting these log entries: ExecRestrPos: node type 18 not supported ExecMarkPos: node type 18 not supported Any idea what they mean? TIA, -km _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
"kurt miller" <miller_kurt_e@hotmail.com> writes:
> I'm getting these log entries:
> ExecRestrPos: node type 18 not supported
> ExecMarkPos: node type 18 not supported
You're hitting the nested-mergejoin bug that was discovered awhile ago.
Aside from the log messages, you are probably getting wrong answers :-(.
Update to 7.0.3 to get the fix.
regards, tom lane
> I'm getting these log entries: > > ExecRestrPos: node type 18 not supported > ExecMarkPos: node type 18 not supported > > Any idea what they mean? As my dad would say, "Oh, that's the ExecRestrPos node thing, it doesn't support the type 18, I think." No, actually, I am not sure what it means. What PostgreSQL version are you running? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
> "kurt miller" <miller_kurt_e@hotmail.com> writes: > > I'm getting these log entries: > > ExecRestrPos: node type 18 not supported > > ExecMarkPos: node type 18 not supported > > You're hitting the nested-mergejoin bug that was discovered awhile ago. > Aside from the log messages, you are probably getting wrong answers :-(. > Update to 7.0.3 to get the fix. Oh, I see Tom knows. I will tell my Dad. :-) -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026