Re: Turn off transitive joins

I don't think there is any need to add any such capability in postgresql,
but I need it for my work.

I need the join qualifiers.
On 15-Oct-2017 1:37 AM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Gourav Kumar <gourav1905(at)gmail(dot)com> writes:
> > Is there some way by which I can tell postgresql to not to consider
> > transitive joins while considering join pairs.
>
> No ... and you have presented no reason whatever why we should consider
> adding such a capability.
>
> Maybe you should be trying to construct your join graph someplace
> earlier, before the optimizer processes the join quals.
>
> regards, tom lane
>