Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] [sqlsmith] Planner crash on foreign table join - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: [HACKERS] [sqlsmith] Planner crash on foreign table join
Date
Msg-id 8737djxrup.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to [HACKERS] [sqlsmith] Planner crash on foreign table join  (Andreas Seltenreich <seltenreich@gmx.de>)
Responses Re: [HACKERS] [sqlsmith] Planner crash on foreign table join
List pgsql-hackers
Tree view 
>>>>> "Andreas" == Andreas Seltenreich <seltenreich@gmx.de> writes:
Andreas> Hi,Andreas> testing master at f0e44021df with a loopback postgres_fdwAndreas> installed, I see lots of crashes
onqueries joining foreignAndreas> tables with various expressions.  Below is a reduced recipeAndreas> for the
regressiondatabase and a backtrace.
 

Commit ac2b095088 assumes that clauselist_selectivity is being passed a
list of RelOptInfo, but postgres_fdw is passing it a list of bare
clauses.  One of them is wrong :-)

-- 
Andrew (irc:RhodiumToad)

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [HACKERS] PoC plpgsql - possibility to force custom or generic plan
Next
From: ilmari@ilmari.org (Dagfinn Ilmari Mannsåker)
Date:
Subject: Re: [HACKERS] [PATCH] Add GUCs for predicate lock promotion thresholds