Re: Optimization for updating foreign tables in Postgres FDW

On Fri, Feb 12, 2016 at 7:19 AM, Etsuro Fujita
<fujita.etsuro@lab.ntt.co.jp> wrote:
> I think that displaying target lists would be confusing for users.  Here is
> an example:
>
> EXPLAIN (verbose, costs off)
> DELETE FROM rem1;                 -- can be pushed down
>                  QUERY PLAN
> ---------------------------------------------
>  Delete on public.rem1
>    ->  Foreign Delete on public.rem1
>          Output: ctid
>          Remote SQL: DELETE FROM public.loc1
> (4 rows)
>
> Should we output the "Output" line?

I see your point, but what if there's a RETURNING clause?

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