ExecRestrPos: node type 18 not supported

"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