Postgres Pro
Downloads
Home   >   mailing lists

Re: ExecRestrPos: node type 18 not supported - Mailing list pgsql-general

From Tom Lane
Subject Re: ExecRestrPos: node type 18 not supported
Date
Msg-id 8119.975533905@sss.pgh.pa.us
Whole thread Raw
In response to ExecRestrPos: node type 18 not supported  ("kurt miller" <miller_kurt_e@hotmail.com>)
Responses Re: ExecRestrPos: node type 18 not supported  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Alex Howansky
Date:
Subject: how to determine what a process is doing
Next
From: Tom Lane
Date:
Subject: Re: how to determine what a process is doing