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
"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
Greetings all,
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 WHERE reading_val = '8';
SE
