Online Documentation for SQL Manager for PostgreSQL
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
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.