Thread: Some information about the small portion of source code of postgreSQL

Some information about the small portion of source code of postgreSQL

From
davinder singh
Date:
Hi,
   I am working in optimizer module of postgreSQL 9.4.1. My project is concerned with the plan returned by the optimizer.

I am trying to return a subplan for a query instead of full plan. For this I need to return a path form RelOptInfo *standard_join_search() at allpaths.c other than from last level of root->join_rel_level().
while doing so I am getting error :variable not found in subplan target lists at function fix_join_expr_mutator at setrefs.c.

It will be great if you can give me some idea about why this error is happening,since this error is happening at above function, Please give me more information about that portion of code. Also I want to know for what targetlist stands for.


Thanks,
Davinder Singh

Re: Some information about the small portion of source code of postgreSQL

From
Ashutosh Bapat
Date:
This mail looks exactly same as that from Shrinivas. Please check answers there.

On Tue, Sep 27, 2016 at 11:32 AM, davinder singh
<davindersingh2692@gmail.com> wrote:
> Hi,
>    I am working in optimizer module of postgreSQL 9.4.1. My project is
> concerned with the plan returned by the optimizer.
>
> I am trying to return a subplan for a query instead of full plan. For this I
> need to return a path form RelOptInfo *standard_join_search() at allpaths.c
> other than from last level of root->join_rel_level().
> while doing so I am getting error :variable not found in subplan target
> lists at function fix_join_expr_mutator at setrefs.c.
>
> It will be great if you can give me some idea about why this error is
> happening,since this error is happening at above function, Please give me
> more information about that portion of code. Also I want to know for what
> targetlist stands for.
>
>
> Thanks,
> Davinder Singh



-- 
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company



Re: Some information about the small portion of source code of postgreSQL

From
Amit Langote
Date:
On 2016/09/28 13:30, Ashutosh Bapat wrote:
> This mail looks exactly same as that from Shrinivas. Please check answers there.

Here is a link to the discussion thread that Ashutosh is referring to:

https://www.postgresql.org/message-id/flat/CAFjFpRfxJJJGNhtQaS2CQ7Boyfo88nu-45JcNKeREUbQUPxOEw%40mail.gmail.com

Thanks,
Amit