MogDB Psycopg2 Release Notes

The MogDB Psycopg2 release notes contains new features, improvements, BUG fixes, and other change descriptions. Please read the details below carefully to understand all changes.

5.0.0.5 (2024-07-01)

修复：

• Fix the autocommit not work when the server parameter compat_oracle_txn_control is set
• Fix the rollback() not work when the server parameter compat_oracle_txn_control is set

Since this release, the driver behavior has changed as follows:

1. The compat_oracle_txn_control option cannot be changed in a session after the connection is established
2. When autocommit=True, the driver automatically removes the compat_oracle_txn_control option within behavior_compat_options
3. When autocommit=False, the driver is keeping the existence of compat_oracle_txn_control within the session consistent with that of parameter behavior_compat_options during connection establishment

5.0.0.4 (2024-04-15)

Fix:

• Fix the autosavepoint not work when the server parameter compat_oracle_txn_control is set

While establishing a connection, you can enable compat_oracle_txn_control by options parameter: conn = psycopg2.connect(..., options="-c behavior_compat_options=compat_oracle_txn_control")

5.0.0.3 (2024.03.28)

Features:

• Added oracle transaction compatibility (Active When the guc parameter behavior_compat_options contains compat_oracle_txn_control)

5.0.0.2 (2023.12.28)

Fix:

• Fixed import error in Python 3.11

5.0.0.1 (2023.10.11)

Features:

• Add the autosavepoint property, which supports calling rollback only to roll back failed statements after a single SQL failure in a transaction
• Add '$' placeholder support
• (extras) Add execute_prepared_batch and execute_params_batch functions
• Supports parsing of boolean fields for '1' and '0'

Fix:

• Empty strings are converted to NULL by default in A compatible mode