Online Documentation for SQL Manager for PostgreSQL

Confirmations

Confirm saving the object (or document) upon closing the editor

If this option is selected, the program requires confirmation each time you want to save changes in a database object or document.

Confirm dropping of object

If this option is selected, the program requires confirmation of dropping a database object.

Confirm exit from SQL Manager

If this option is selected, you are prompted for confirmation each time when you exit the application.

Confirm deleting records

This option enables/disables a confirmation dialog for deleting records.

Confirm metadata changing (Changing Metadata Window)

This option enables/disables the Changing Metadata window.

Confirm addition into spell checking dictionary

Enable this option if you wish to be prompted for adding a word to the dictionary which is used for checking words spelling (see Spell Checking).

Confirm transformation of misprint into substitution

If this option is selected, you need to confirm replacing a misprinted word with a corresponding substitution word (see Spell Checking).

Confirm transaction commit

If this option is selected, the program requires confirmation on attempt to commit a transaction.

Confirm transaction rollback

If this option is selected, the program requires confirmation on attempt to rollback a transaction.

Confirm transaction commit on closing data in object editors

If this option is selected, the program prompts to commit the transaction upon closing the 'Data' tab in object editors.

Transaction confirmation in Query Data and Design Query

Disable transaction confirmation on closing the editor

If this option is checked, no transaction confirmation will be required on closing Query Data and Design Query.

Default action on closing the editor

Specify the default action (Commit or Rollback) and this action will be performed automatically each time when you exit Design Query or Query Data.

Table altering operations performed via recreation

This option defines SQL Manager for PostgreSQL behavior when it is necessary to recreate a table to perform requested changes over it:

Enabled - such operations will be performed without warnings;

Enabled, show warning - the warning window will appear if an operation requires table recreation;

Disabled - denies operations of this type.