Re: Optimization for updating foreign tables in Postgres FDW

On 2015/03/04 16:58, Albe Laurenz wrote:
> Etsuro Fujita wrote:
>> While updating the patch, I noticed that in the previous patch, there is
>> a bug in pushing down parameterized UPDATE/DELETE queries; generic plans
>> for such queries fail with a can't-happen error.  I fixed the bug and
>> tried to add the regression tests that execute the generic plans, but I
>> couldn't because I can't figure out how to force generic plans.  Is
>> there any way to do that?
>
> I don't know about a way to force it, but if you run the statement six
> times, it will probably switch to a generic plan.

Yeah, I was just thinking running the statement six times in the 
regression tests ...

Thanks!

Best regards,
Etsuro Fujita