Re: Push down more full joins in postgres_fdw - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Push down more full joins in postgres_fdw
Date
Msg-id CA+TgmoZcaJ=F-CKF0v_MOd-tMij8if1JOcyVzz05Uv8h80msJA@mail.gmail.com
Whole thread Raw
In response to Re: Push down more full joins in postgres_fdw  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Responses Re: Push down more full joins in postgres_fdw  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List pgsql-hackers
On Tue, Sep 6, 2016 at 9:07 AM, Ashutosh Bapat
<ashutosh.bapat@enterprisedb.com> wrote:
> That's not true with the alias information. As long as we detect which
> relations need subqueries, their RTIs are enough to create unique aliases
> e.g. if a relation involves RTIs 1, 2, 3 corresponding subquery can have
> alias r123 without conflicting with any other alias.

What if RTI 123 is also used in the query?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: PassDownLimitBound for ForeignScan/CustomScan
Next
From: Robert Haas
Date:
Subject: Re: DISABLE_PAGE_SKIPPING option for vacuumdb