Re: [HACKERS] Add support for tuple routing to foreign partitions

Hi Amit,

(2018/03/20 15:57), Amit Langote wrote:
> On 2018/03/19 20:25, Amit Langote wrote:
>> That's all I have for now.

Will reply to your previous email.

> While testing this patch, I noticed a crash when performing EXPLAIN on
> update of a partition tree containing foreign partitions.  Crash occurs in
> postgresEndForeignRouting() due to the following Assert failing:
>
>    Assert(fmstate != NULL);
>
> It seems the problem is that ExecCleanupTupleRouting() invokes the
> EndForeignRouting() function even if ri_PartitionIsValid is not set.  So I
> suppose we need this:
>
>           /*
> -         * If this is INSERT/UPDATE, allow any FDWs to shut down
> +         * If this is INSERT/UPDATE, allow any FDWs to shut down if it has
> +         * initialized tuple routing information at all.
>            */
>           if (node&&
> +            resultRelInfo->ri_PartitionIsValid&&
>               resultRelInfo->ri_FdwRoutine != NULL&&
>               resultRelInfo->ri_FdwRoutine->EndForeignRouting != NULL)
>               resultRelInfo->ri_FdwRoutine->EndForeignRouting(node->ps.state,

Will look into this.

> BTW,patch needs to be rebased because of two commits this morning:
> 6666ee49f [1] and ee0a1fc84 [2].

Will do.

Thanks for reviewing the patch!

Best regards,
Etsuro Fujita