Data Integrity on PostgreSQL

The commit and rollback commands are supported.

Transaction Control

The connector does not change transaction state before entering and before leaving the sql ProcScript statement. This is left to the ODBC driver manager. If possible, avoid transaction processing because the connector cannot manage a transaction that it did not initiate.

The commands that involve transaction management are:

commit (Uniface command)
rollback (Uniface command)
commit transaction
rollback transaction
begin transaction

Note: If you perform transaction management, once the transaction finishes you must ensure that the logon path is returned to the same state that it was in before the transaction management was performed. If do not do this, the PostgreSQL driver transaction manager does not understand the correct state of the connection.

Locking Strategies

The connector supports Optimistic, Cautious and Paranoid locking. For more information, see Locking Strategies.

Referential Integrity

The PGS connector supports the creation of scripts that will enforce the referential integrity in the database.