Released: Dec 3, 2024

Mises à jour de V4.0.1

Fonctionnalités

dbForge Studio for PostgreSQL V3.2.47

• Connectivity:
  • Added support for PostgreSQL 17.
  • Added support for AlloyDB.
  • Added support for Supabase.
  • Added support for Google Cloud.
  • Added support for Azure Cosmos DB for PostgreSQL.
  • Added support for the rds-ca-rsa2048-g1 SSL/TLS certificate for connecting to PostgreSQL servers on Amazon Web Services.
• Text Editor:
  • Added parameter info and quick info for functions and procedures.
  • Added suggestions for foreign key columns in ON DELETE SET NULL and ON DELETE SET DEFAULT clauses.
  • Added suggestions for columns declared in scripts for foreign keys within CREATE TABLE and ALTER TABLE clauses.
  • Added suggestions for existing triggers, ENABLE REPLICA, ENABLE ALWAYS, and potential owners in ALTER EVENT TRIGGER clauses.
  • Added suggestions for existing triggers in DROP EVENT TRIGGER clauses.
  • Added suggestions for CREATE OR REPLACE, FOR EACH ROW, FOR EACH STATEMENT, DEFERRABLE INITIALLY DEFERRED, and DEFERRABLE INITIALLY IMMEDIATE in CREATE TRIGGER clauses.
  • Added suggestions for triggers along with the tables and views they are based on in ALTER TRIGGER clauses.
  • Redesigned Query History, whose toolbar now includes an updated range selection and a button that clears the history.
  • Added the ability to duplicate, remove, and join current lines in SQL documents using shortcuts.
• Schema and Data Compare:
  • Added support for foreign key columns in ON DELETE SET NULL and ON DELETE SET DEFAULT clauses in Schema Compare.
  • Added support for the comparison and synchronization of DML and event (DDL) triggers in Schema Compare.
  • Improved the comparison and synchronization of UNIQUE constraints in Schema Compare.
  • Added full support for the comparison and synchronization of CHECK constraints in Schema Compare.
  • Implemented access to the automated generation of comparison reports directly from the Comparison Report wizard in Schema Compare and Data Compare.
  • Added new customization options for the automated generation of comparison reports in Schema Compare and Data Compare.
• Data Generator:
  • Added new basic generators to Data Generator, including Files Folder, Lorem Ipsum, Shuffled Text, and Text File.
  • Added new smart generators to Data Generator in the following categories: Business, IT, Payment, Location, Product, Health, and Personal.
  • Added a new option in Data Population Wizard that appends a timestamp to the name of the data population script file.
• Database Explorer:
  • Added an option to delete database objects directly from the context menu in Database Explorer.
  • Added an option to generate the DDL of materialized views in Amazon Redshift from the context menu.
• Others improvements:
  • Implemented direct data export from the Data Editor grid to an Excel file from the context menu.
  • Implemented an option that sets the value of a cell to a unique identifier from the Data Editor context menu.
  • Added quick access to PostgreSQL-related demos and tutorials of Devart Academy from the Help menu.
  • Improved support for special values in datetime datatypes.
  • Added support for ON UPDATE CASCADE and ON DELETE CASCADE clauses to be applied during the re-creation of foreign keys for data synchronization.
  • Added support for the parsing of the DISTSTYLE keyword in CREATE TABLE statements for Amazon Redshift.
  • Improved the display of the completion list where every owner name was attached to the corresponding element name; now owners are displayed in a separate column.
  • Added the ability to delete an empty line using the Shift+Delete key combination.
  • Improved the insertion of date and time data from the clipboard to a cell in Data Editor.
  • Improved the export of large volumes of blob data to a file from Data Viewer.
  • Improved error handling behavior when describing objects for code completion.
  • Added the ability to display subobjects for DML triggers in Database Explorer.
  • Improved the display and calculation of the optimal width of the row number column in Data Editor.
  • Added the ability to close a floating window using the Ctrl+F4 key combination.
  • Improved the display of the cursor.
  • Added diagnostics to determine the cause of errors.
  • Added the auto-selection of the column type for suggestions.
  • Extended the error message displayed in the Error List window with additional information.

Correctifs

dbForge Studio for PostgreSQL V3.2.47

• Fixed metadata retrieval that could fail on specific server versions.
• Fixed an issue with the deletion of words during multi-line selection in the editor.
• Fixed an issue with the parsing of the LIKE ANY construct.
• Fixed an issue with multi-line selection caused by tab characters in the text.
• Fixed an issue with the recovery of a deleted selection when performing an undo operation in the editor.
• Fixed the quoting of case-sensitive column names during the insertion from the completion list.
• Fixed the deselection behavior in the text editor shown in a floating window.
• Fixed repeated password requests for SSH connections.
• Fixed the display of data in Data Viewer when double-clicking it in Data Editor.
• Fixed an issue that occurred when deleting a command in a SQL document.
• Fixed an issue that occurred after restoring a SQL document upon opening the Studio.
• Fixed a lag in Data Editor that occurred during the execution of a query against a large table in the paginal mode.
• Fixed the 'canceling statement due to user request' error that occurred during multiple repeated executions of a query in a SQL document.
• Fixed an issue with table names that occurred when generating INSERT commands during data export.
• Fixed an issue with unnecessary quotation marks being added to values when copying data from Data Editor.
• Fixed an issue with the failed selection of the last line in a SQL document.
• Fixed the selection of the current database in the Data Export wizard.
• Fixed an issue with the 'Execute Current Statement' command that occurred after modifying the query text in a SQL document.
• Fixed a lag that occurred when pointing to a table name in a SQL document.
• Fixed the behavior of the 'Activate Data Editor after query execution' option.
• Fixed the issue with incorrect text selection in a SQL document.