Custom FDW - the results of a nested query/join not being passed as qual to the outer query

2021-01-27 Thread Kai Daguerre
Hi! (First post. If this is not the appropriate list, please feel free to move or let me know. ) I am developing an FDW which allows various data sources to act as virtual tables, allowing various different APIs to be queried using a consistent SQL interface - a similar concept to Osquery but usi

Re: Custom FDW - the results of a nested query/join not being passed as qual to the outer query

2021-01-27 Thread Tom Lane
Kai Daguerre writes: > We often have virtual tables where a list operation is not viable/possible > without providing quals. For example we have implemented a 'whois' table, > which will retrieve whois information for specified domains. It is clearly > not practical to do an unqualified 'list' of