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

From Sergiy Zuban
Subject Re: postgres_fdw - push down conditionals for ENUMs
Date
Msg-id CAGz8fGbmdMOLApH1nAf=088QOho=iCOG82pWypYP64BGnR0Y3g@mail.gmail.com
Whole thread Raw
In response to Re: postgres_fdw - push down conditionals for ENUMs  (Sergiy Zuban <s.zuban@gmail.com>)
List pgsql-general
> 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.

Its bad. I think most users would be happy to have "auto discovery" mode when foreign table fetches all required meta info to act like original table.
 
Since 9.5 has IMPORT FOREIGN SCHEMA don't you think that foreign tables can be marked as "imported". This 100% guarantees that all user-defined data types/domains (including ENUMs) imported as well. It should be safe to push down conditionals for imported types. Does it makes sense?

pgsql-general by date:

Previous
From: Casey Deccio
Date:
Subject: alter column type
Next
From: Shuwn Yuan Tee
Date:
Subject: Re: replicating many to one