Enhancements:
- Add support for
IMPORT FOREIGN SCHEMAfor PostgreSQL 9.5 and higher. - Improve cost estimates by using the row count estimate.
Inspiration by Daniele Sevegnani. - Support two-dimensional geometries with an additional measure dimension.
Idea by Paul Dziemiela. - Throw an error if
oracle_close_connections()is called inside a transaction that modified Oracle data.
Bugfixes:
- The server crashed for the constructs like
<column> = ANY (NULL).
Report and patch by dreckard. - oracle_fdw sometimes failed to recognize the SDO_GEOMETRY data type.
Per report from Bevan Jenkins. - Some point geometries were not translated properly.
Per report from Bevan Jenkins. - Ignore SDO_GEOMETRY elements with zero SDO_ETYPE.
According to Oracle, that is the correct behaviour.
Per report from Bevan Jenkins. - Fix
EXPLAIN (VERBOSE)for queries containing current_timestamp.
This caused "ORA-30081: invalid data type for datetime/interval arithmetic".
Noticed by "kkwhite". - Oracle TIMESTAMP(0) fields caused errors like:
ERROR: invalid input syntax for type timestamp: "1977-06-09 18:00:00."
Also, handling of dates and timestamps before Christ was broken.
Report by "abiuan".