ORACLE_FDW_1_5_0
版本发布时间: 2016-08-05 17:29:45
laurenz/oracle_fdw最新发布版本:ORACLE_FDW_2_6_0(2023-09-09 01:29:40)
Enhancements:
- Add table option
sample_percent
toANALYZE
very large tables
This can speed upANALYZE
significantly.
Idea by @legrandlegrand. - Introduce a table option
prefetch
for the Oracle row prefetch count
This can speed up foreign table scans.
Per discussion with by @legrandlegrand and @3kkani. - Push down arbitrary
IN
andNOT IN
expressions
Up to now, only lists with constants were considered.
Per request from @volkmarbuehringer. - Push down
ORDER BY
expressions to Oracle from PostgreSQL 9.2 on
Only expressions of numeric, date and timestamp datatypes are pushed down, since the string collations in PostgreSQL and Oracle cannot be guaranteed to be the same.
Courtesy of NTT OSS Center, patch by @yamatattsu.
Bugfixes:
- Fix errors with
now()
and date/timestamp parameters in queries
This bug was introduced in 1.3.0 and caused errors like
ERROR: error executing query: OCIDateTimeFromText failed to convert parameter
DETAIL: ORA-01843: not a valid month
whennow()
orcurrent_timestamp
and friends or date/timestamp parameters were used.
Report by Li Hailong. - Fix errors when updating date/timestamp columns
This bug was also introduced in 1.3.0 and caused errors like
ORA-01856: BC/B.C. or AD/A.D. required
if the Oracle and PostgreSQL types were different.
Report by @sttachoires. -
IMPORT FOREIGN SCHEMA
sometimes didn't import primary keys
Report by @JMLessard, fix by @legrandlegrand. - Fix memory leaks during
ANALYZE
This caused out of memory errors when large tables were analyzed.
Report by @acheccuc. -
IMPORT FOREIGN SCHEMA
should not tolerate missing remote schema
It used to cause a warning, but the SQL standard requires an error.
Report by @JMLessard. - Fix crash when
UPDATE
ing non-existent columns
If a foreign table has more columns than the underlying Oracle table, these additional columns are treated as containingNULL
s.
However, oracle_fdw crashed on an attempt to change such a column with anUPDATE
statement, which should not happen. Reported by @fnicollet. - Fetch all columns from Oracle when the whole row is referenced
This problem could lead to wrongNULL
values in trigger functions or when the whole column is used in an expression.
Reported by @fnicollet.
1、 oracle_fdw-1.5.0-pg91-win32.zip 182.85KB
2、 oracle_fdw-1.5.0-pg91-win64.zip 187.74KB
3、 oracle_fdw-1.5.0-pg92-win32.zip 228.68KB
4、 oracle_fdw-1.5.0-pg92-win64.zip 195.44KB
5、 oracle_fdw-1.5.0-pg93-win32.zip 243.47KB
6、 oracle_fdw-1.5.0-pg93-win64.zip 206.9KB
7、 oracle_fdw-1.5.0-pg94-win32.zip 235.22KB
8、 oracle_fdw-1.5.0-pg94-win64.zip 244.59KB
9、 oracle_fdw-1.5.0-pg95-win32.zip 242.69KB
10、 oracle_fdw-1.5.0-pg95-win64.zip 245.57KB
11、 oracle_fdw-1.5.0-pg96-win32.zip 260.53KB
12、 oracle_fdw-1.5.0-pg96-win64.zip 243.18KB