Re: [GENERAL] postgres_fdw - push down conditionals for ENUMs

2015-06-05 Thread Sergiy Zuban
> > > 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 ha

[GENERAL] postgres_fdw - IS TRUE/FALSE conditions are not pushed down

2014-07-21 Thread Sergiy Zuban
(cost=100.00..138.52 rows=14 width=5) Output: id, active Remote SQL: SELECT id, active FROM main_testing.t_url WHERE ((active IS NULL)) DO I need to report this as bug? Tested on PostgreSQL 9.3.4 -- Sergiy Zuban

[GENERAL] postgres_fdw - push down conditionals for ENUMs

2014-07-21 Thread Sergiy Zuban
all data types? 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? Thanks. Tested on 9.3.4 -- Sergiy Zuban

Re: [GENERAL] postgres_fdw - push down conditionals for ENUMs

2014-07-25 Thread Sergiy Zuban
> > > 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