Re: postgres_fdw pushdown problem.

2018-11-20 Thread Rhys A.D. Stewart
The devil really is in the details. > end might be using a different timezone setting.) I'm pretty sure > either timestamp = timestamp or timestamptz = timestamptz would be > pushable. Yeah, casting to plain old timestamp worked. Thanks Tom. Rhys Peace & Love|Live Long & Prosper

Re: postgres_fdw pushdown problem.

2018-11-20 Thread Tom Lane
"Rhys A.D. Stewart" writes: > I'm using postgres_fdw and am having a pushdown issue. The TL;DR is > that the where clause doesn't get pushed down for the last of the > following three queries. > SELECT * FROM service.mrrdr_synth WHERE premises = '1057430'; > SELECT * FROM service.mrrdr_synth WHER