Re: postgres_fdw - push down conditionals for ENUMs - Mailing list pgsql-general

From Tom Lane
Subject Re: postgres_fdw - push down conditionals for ENUMs
Date
Msg-id 3549.1405959403@sss.pgh.pa.us
Whole thread Raw
In response to postgres_fdw - push down conditionals for ENUMs  (Sergiy Zuban <s.zuban@gmail.com>)
Responses Re: postgres_fdw - push down conditionals for ENUMs  (Sergiy Zuban <s.zuban@gmail.com>)
List pgsql-general
Sergiy Zuban <s.zuban@gmail.com> writes:
> 1. Is there any plans to add "non-strict mode" (configurable via options on
> server/table/column level) to allow pushing down conditions for all data
> types?

No.  You might as well call it a "return random answers" mode.

> 2. There is an option that allows to map foreign table column to column
> with another name. What about adding another option to specify column type
> to be send to remote server?

Same problem.  We don't have any way of knowing whether type foo on the
remote end acts like foo locally.

            regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgres_fdw - IS TRUE/FALSE conditions are not pushed down
Next
From: David G Johnston
Date:
Subject: Re: statement_timeout doesn't work