Enhancements:
- Add option readonly for IMPORT FOREIGN TABLE that sets the foreign table option readonly to true on all imported foreign tables.
Idea by @jgoux. - Allow foreign tables based on arbitrary Oracle queries.
The query, enclosed in parentheses, can be supplied as option table.
Requested by @tsykes, @cirix81 and @jgoux.
Bugfixes:
- Selecting timestamps with lc_messages other than English caused errors like
ORA-01406: la valeur de la colonne extraite a été tronquée
Report by @dszczyt. - Complicated queries could lead to an error like
Internal oracle_fdw error: encountered unknown node type 524.
Report by @bartonjd. - PostGIS type geometry cannot be found if ArcGIS is installed.
Report by @dtoller.