darold/ora2pg v24.3

Version 24.3

on GitHub

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.