SQL Support for PostgreSQL

Allowed Commands

For a complete list of reserved words for SQL commands that cannot be executed within a user transaction, see the PostgreSQL documentation. The network protocol you are using can influence the type of commands you are allowed to issue.

Transaction Control

The PGS connector does not change transaction state before entering and before leaving the sql ProcScript statement.

Transaction processing should be avoided in SQL Editor and sql ProcScript, because the connector cannot manage a transaction which it did not initiate. The commands which involve transaction management are as follows:

• commit (ProcScript command)
• rollback (ProcScript 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 you do not do this, the PGS connector does not understand the correct state of the connection.

Monitoring SQL in the Message Frame

If requested in the start-up shell, the SQL generated by Uniface can be sent to the message frame. User-defined messages from stored procedures also appear here. Database error messages are always sent to the message frame.

Stored Procedures

It is possible to execute stored procedures using SQL, but not service stored procedures.