Re: Postgres_fdw join pushdown - wrong results with whole-row reference - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: Postgres_fdw join pushdown - wrong results with whole-row reference
Date
Msg-id 4486e69f-5c8d-9d9e-db70-117e2a0fafec@lab.ntt.co.jp
Whole thread Raw
In response to Re: Postgres_fdw join pushdown - wrong results with whole-row reference  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Responses Re: Postgres_fdw join pushdown - wrong results with whole-row reference  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List pgsql-hackers
On 2016/06/28 13:53, Ashutosh Bapat wrote:
> Ideally, we should point out the specific column that faced the
> conversion problem and report it, instead of saying the whole row
> reference conversion caused the problem. But that may be too difficult.

I think so too.

> Or at least the error message should read "whole row reference of
> foreign table ft1".

OK, attached is an updated version of the patch, which uses "whole-row
reference", not "wholerow".

Best regards,
Etsuro Fujita

Attachment

pgsql-hackers by date:

Previous
From: Rushabh Lathia
Date:
Subject: ERROR: ORDER/GROUP BY expression not found in targetlist
Next
From: Ashutosh Bapat
Date:
Subject: Re: Postgres_fdw join pushdown - wrong results with whole-row reference