postgres_fdw passes/does not pass the LIMIT clause to the remote destination
2
votes
1
answer
58
views
I'm making a FDW (Foreign Data Wrapper) in PostgreSQL for myself using C.
And in the test environment below,
myFDW receives the query with/without
LIMIT
clause case by case.
Test environment:
psql → PC1(Postgresql + postgres_fdw) → PC2(Postgresql + myFDW) → tableA@myUniqueDB
tableA
:
- ts
as timestamp
- data1
as integer
Such as when I type the following in psql:
select ts
from tableA
where (ts > '2022-01-01')
and (ts '2022-01-01')
and (ts '2022-01-01')
and (ts '2022-01-01')
and (ts < '2022-12-31');
Asked by toratora7964
(21 rep)
Feb 15, 2024, 05:26 AM
Last activity: Feb 26, 2024, 03:48 AM
Last activity: Feb 26, 2024, 03:48 AM