Re: postgres_fdw - push down conditionals for ENUMs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sergiy Zuban <s(dot)zuban(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgres_fdw - push down conditionals for ENUMs
Date: 2014-07-21 16:16:43
Message-ID: 3549.1405959403@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sergiy Zuban <s(dot)zuban(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2014-07-21 17:16:19 Re: statement_timeout doesn't work
Previous Message Tom Lane 2014-07-21 16:13:42 Re: postgres_fdw - IS TRUE/FALSE conditions are not pushed down