Sample Header Ad - 728x90

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