Download Latest Version Version 25.0 source code.tar.gz (590.4 kB)
Email in envelope

Get an email when there's a new version of Ora2Pg

Home / v24.3
Name Modified Size InfoDownloads / Week
Parent folder
README.md 2024-03-28 2.6 kB
0
Version 24.3 source code.tar.gz 2024-03-28 577.1 kB
0
Version 24.3 source code.zip 2024-03-28 591.9 kB
0
Totals: 3 Items   1.2 MB 0

2024 03 29 - v24.3

This release fix several issues reported since last release and adds some new features and improvements.

  • Add option control the "prefetch" used by oracle_fdw COPY/INSERT Prior to this change Ora2Pg uses the default "prefetch" of oracle_fdw, which at the time of writing is 50. Allowing this to be controlled by an Ora2Pg configuration/option gives the option of increased performance at the cost of some additional memory on the PostgreSQL side. Thanks to Martin Nash for the patch.

  • Modify the behavior of triggers export with EXPORT_INVALID. It used to apply to ENABLED or DISABLED triggers instead of real VALID or INVALID triggers. Export of INVALID triggers will be controlled by EXPORT_INVALID like others objects like functions, packages, etc. This mean that disabled triggers that are valid will be exported by default now, this was not the case before. Thanks to dcgadmin for the feature request.

  • Add new configuration directive PGTT_NOSUPERUSER. By default the pgtt extension is loaded using the superuser privilege when EXPORT_GTT is activated. Enabled it if you run the SQL scripts generated using a non superuser user. It will use:

    LOAD '$libdir/plugins/pgtt';

    instead of default:

    LOAD 'pgtt';

    Thanks to Simon Martin for the feature request.

Here is the full list of changes and acknowledgements:

  • Fix Inf replacement that must only be done with numeric datatype. Thanks to gael-efluid for the report.
  • Fix some replacement of OUTER JOIN (+). Thanks to Carens Kurniawan Wijaya for the report.
  • Fix schema filter with test function count. Thanks to dcgadmin for the report.
  • Fix TEST count objects when a table name is modified. Thanks to korolan for the report.
  • Fix issue with multi style comments. Thanks to newtglobal.com for the patch.
  • Fix documentation about EXPORT_INVALID to precise that it also concern disabled triggers. Thanks to dcgadmin for the report.
  • Fix missing FOR EACH clause in trigger export after a regression introduced by commit fb6b0ad. Thanks to Carens Kurniawan Wijaya for the report.
  • Fix data export for table with a geometry column. Thanks to ruralqiu for the report.
  • Revert changes introduced by commit fc7008c, for some obscurs Oracle reasons the DBA_SDO_GEOM_METADATA doesn't always exist. Always uses ALL_SDO_GEOM_METADATA instead. Thanks to ruralqiu and Pierre3939 for the report.
Source: README.md, updated 2024-03-28