3.2.47 03-Dec-24
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 Compares
- 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
User-reported and internal bug fixes
- Fixed metadata retrieval that could fail on specific server versions (D154740)
- Improved support for special values in datetime datatypes (D139021)
- Added support for ON UPDATE CASCADE and ON DELETE CASCADE clauses to be applied during the re-creation of foreign keys for data synchronization (D155811, D167879)
- Added support for the parsing of the DISTSTYLE keyword in CREATE TABLE statements for Amazon Redshift (D151002)
- Fixed an issue with the deletion of words during multi-line selection in the editor (D149219)
- Fixed an issue with the parsing of the LIKE ANY construct (D148245)
- Fixed an issue with multi-line selection caused by tab characters in the text (D143567)
- Fixed an issue with the recovery of a deleted selection when performing an undo operation in the editor (D146741)
- Fixed the quoting of case-sensitive column names during the insertion from the completion list (D144980)
- 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 (D143565)
- Added the ability to delete an empty line using the Shift+Delete key combination (D141949)
- Fixed the deselection behavior in the text editor shown in a floating window (D146113)
- Improved the insertion of date and time data from the clipboard to a cell in Data Editor (D148236)
- Improved the export of large volumes of blob data to a file from Data Viewer (D170044)
- Fixed repeated password requests for SSH connections (D164049)
- Improved error handling behavior when describing objects for code completion (D161730)
- Added the ability to display subobjects for DML triggers in Database Explorer (D152468)
- Improved the display and calculation of the optimal width of the row number column in Data Editor (D142475)
- Fixed the display of data in Data Viewer when double-clicking it in Data Editor (D147103)
- Fixed an issue that occurred when deleting a command in an SQL document (D146736)
- Fixed an issue that occurred after restoring an SQL document upon opening the Studio (D148363)
- Fixed a lag in Data Editor that occurred during the execution of a query against a large table in the paginal mode (D146744)
- Fixed the 'canceling statement due to user request' error that occurred during multiple repeated executions of a query in an SQL document (D145274)
- Fixed an issue with table names that occurred when generating INSERT commands during data export (D146069)
- Fixed an issue with unnecessary quotation marks being added to values when copying data from Data Editor (D146287)
- Fixed an issue with the failed selection of the last line in an SQL document (D146340)
- Fixed the selection of the current database in the Data Export wizard (D146737)
- Added the ability to close a floating window using the Ctrl+F4 key combination (D145259)
- Fixed an issue with the 'Execute Current Statement' command that occurred after modifying the query text in an SQL document (D141953)
- Fixed a lag that occurred when pointing to a table name in an SQL document (D146110)
- Improved the display of the cursor (D145395)
- Added diagnostics to determine the cause of errors (D147104)
- Added the auto-selection of the column type for suggestions (D141625)
- Fixed the behavior of the option 'Activate Data Editor after query execution' (D118496, D130770)
- Fixed the issue with incorrect text selection in an SQL document (D146751, D145094, D145398)
- Extended the error message displayed in the Error List window with additional information (D141957, D75630)
3.1.839 17-Jan-24
User-reported and internal bug fixes
- Fixed an error that occurs when switching between Card View and Grid View in the Data Editor
3.1.832 10-Jan-24
Schema Compare
- New Alt + Up/Down Arrow shortcuts for navigating script differences in the lower comparison pane
User-reported and internal bug fixes
- Several user reported minor bugs are fixed
3.1.789 27-Nov-23
Improvements
- Upgraded from legacy chart designer to advanced new version
- Added support for displaying trigger fire on SQL Profiler diagram
- Added support for server sequences starting from PostgreSQL server version 9.1
- Added support for event triggers in the Generate Script As functionality
User-reported and internal bug fixes
- Resolved an issue with column name encoding in scripts generated for Redshift (D130582)
- Fixed potential product crash on CrossOver during window animation processing (D134916)
- Resolved SELECT query execution error occurring with edit mode activated in Data Editor (D119388, D120119, D120443)
- Enhanced syntax checking to include support for the pgvector extension types (D138105, D127261)
- Resolved the issue of quote duplication during data copying from Data Editor (D131873)
- Fixed error encountered when trying to display the smart tag window (D133770, D138738)
3.1.701 18-Aug-23
User-reported and internal bug fixes
- Fixed an error that occurred when parsing the bodies of scripts containing CREATE FUNCTION/PROCEDURE statements
3.1.696 16-Aug-23
Connectivity
- Added support for PostgreSQL 16
User-reported and internal bug fixes
- Fixed an issue with the quoting of case-sensitive names that occurred during the generation of a synchronization script (D120232)
- Fixed an issue that occurred when expanding the Views node in Database Explorer (D123110)
- Fixed an issue that occurred when expanding the database list in SQL Document (D127740)
- Fixed the incorrect display of fonts that occurred when opening the Studio on Linux or macOS via CrossOver (D118342)
- Fixed the incorrect display of the fractional part for the INTERVAL data type (D118190, D118202)
- Fixed an issue with the Connection Manager (D123748)
- Fixed an issue that occurred when exporting data containing floating-point numbers (D123443, D126756)
3.1.618 24-May-23
Connectivity
- Added support for EDB BigAnimal
- Added support for TLS 1.3
- Added the ability to connect to the database server via SSH using SHA-256/512 algorithms
- Added support for Aiven Cloud
Improvements
- Optimized the process of retrieving the number of records in a table
- Added the ability to save user-defined column layouts in Query History
- Added a collection of new code snippets
- Added new options for effective tab management
- Added support for the UNLOGGED keyword in the CREATE UNLOGGED SEQUENCE command
- Improved the behavior of the Disable DML trigger option
User-reported and internal bug fixes
- Fixed an error that occurred when using a shared folder on the disk for query cache in Query History (D115047)
- Improved the behavior of the Generate Script AS functionality for creating scripts with values as INSERT and UPDATE statements (D117929)
- Added alphabetical sorting of triggers in the Database Explorer (D109264)
- Fixed an error that occurred when generating the Quick Info tooltip (D117836)
- Added the ability to configure formats for the Boolean data type in the Data Import wizard (D113260)
- Fixed an issue with profiling parameterized queries (D118167)
- Fixed an issue with processing tables containing columns of PostGIS data types (D115841, D117345, D114863, D113588, D113628, D113826, D114439, D114862)
- Fixed the suggestions behavior on databases with foreign tables (D114505)
- Fixed an issue with the suggestions generation in SQL editor (D113473)
3.0.472 30-Jan-23
General
- Added support for Linux and macOS using CrossOver
Added new Professional Edition, which includes:
- Data Compare
- Schema Compare
- Data Generator
- Export of Query History to the CSV format
- Command-line support for the following functionality: Data Compare, Schema Compare, Data Generator, Execute Large Scripts, as well as Data Export and Import
Text Editor enhancements
- Added support for the SELECT INTO statement
- Added suggestions for the names of non-aggregated columns in the GROUP BY clause
- Added quick navigation between brackets
- Added support for Ctrl+C/X/V hotkeys for coping/cutting entire line in SQL documents
- Introduced a triple-click to select the entire line in SQL documents
- Added support for RAISE [ NOTICE | WARNING | INFO ] to trace userscript messages in the Error List & Output windows
- Added pop-up execution notifications
- Added transaction reminders
- Added capability to set quotes for identifiers when generating scripts
- Added support for Amazon Redshift databases query profiling
- Added the auto-refresh of local cache with an option to ignore selected databases
Other
- Added support for PostgreSQL 15
- Extended support for high-DPI devices
- Improved the behavior of the Retrieve Data feature
- Added support for AWS Babelfish
- Added support for YugabyteDB
- Added support for Neon.tech
- Added support for Digitalocean Managed Databases
- Added support for CitusData
- Added support for ApsaraDB
- Added support for PolarDB
- Added support for AnalyticDB
- Added support for Bit.io
User-reported and internal bug fixes
- Fixed an error with an incorrect sequence of disabling restrictions that occurred during data synchronization (D48577)
- Resolved an issue that occurred when importing data from a OneDrive spreadsheet (D65376, D92269)
- Added support for query profiling on older versions of PostgreSQL (T318300)
- Fixed an issue that took place while working with the trial version (T323376)
- Fixed an error that occurred when connecting to a PostgreSQL database hosted on DigitalOcean (D51449)
- Fixed an error that occurred when exporting data that contain accent marks (D72383)
- Fixed the retrieval of high-precision floating-point numbers (D74191)
- Fixed application freezing that occurred when getting data from a table with a TEXT column (D62033)
- Fixed application freezing (D81773)
- Fixed an error that occurred when opening the Start Page window (D84519, D84793, D88001)
- Fixed an error that occurred on application launch (D93321)
- Fixed an error that occurred when retrieving data for a 'scale' table (D85089)
- Implemented shortcuts to switch between SQL Document tabs (D104137)
- Resolved the Drag & Drop issue in Database Explorer (D99933)
- Fixed a bug with the activation of the JSON tab for the JSON and JSONB data types when viewing data in Data Viewer (u33690838)
- Fixed an error that occurred when retrieving data from array columns (D94900)
- Added the Owner Use field for procedures and functions in the Properties window (D85062)
- Fixed an error that occurred when establishing a server connection (D78820, D82508, D95889)
- Improved data comparison performance in Data Compare (D77330)
- Fixed comparison and synchronization of the RESTRICT, CASCADE, and NO ACTION values for foreign keys in Schema Compare (D74998)
- Fixed Data Editor context menu (D68016)
- Fixed metadata retrieval for Code Completion (D67261)
- Improved Data Editor functionality (D50052)
- Substituted the error that occurred when trying to access the pg_shadow schema in Schema Compare without proper rights with a warning (D69369)
- Fixed an error that occurred when removing a connection from Database Explorer using the keyboard shortcuts (D67111, D75937)
- Fixed an error that occurred when comparing the data types of procedure parameters (D65629)
- Fixed the retrieval of database objects on older versions of PostgreSQL (D66474)
- Extended the query execution error message with more detailed information (D62014)
- Removed extra brackets in the generated view script (D101162)
- Fixed an error that occurred when exporting data (D98600)
- Fixed an error that occurred when importing data from Excel (D96902)
- Fixed an error that occurred when using the DESCRIBE command in Schema Compare (D74998)
- Fixed the Ignore Case option in Data Compare (D81596)
- Resolved an issue with table columns comparison (D76561)
- Added a possibility to make changes to a document connection after deleting a database (D73381)
- Fixed an error that occurred when getting DDL of an inherited table
- Fixed an error that occurred when opening a SQL document with query profiling results
- Fixed the display of query execution time
2.3.287 22-Nov-22
User-reported and internal bug fixes
- Fixed PostgreSQL connection issues (D103934, D103042)
- Fixed several minor errors
2.3.285 15-Jul-22
User-reported and internal bug fixes
- Fixed compatibility issues with the latest Windows 11 updates (D84717,D85016,D90557)
2.3.280 20-May-22
Improvements
- Support for scram-sha-256 (D309923)
User-reported and internal bug fixes
- Fixed a UI error (D69559, D82938, D85479, D85652)
- Fixed an error that occurred when working with the editor in SQL document (D80951)
- Fixed an issue with inserting items from a dropdown list (D81792)
- Fixed a problem with establishing SSPI connection with the server (D85562)
2.3.278 20-Oct-21
New features
- Connectivity support for PostgreSQL 14
User-reported and internal bug fixes
- The application fails with a critical error when trying to create diagram objects after installing the KB5006670, KB5006672 or KB5006674 Windows update
2.3.273 12-Aug-21
User-reported and internal bug fixes
- Resolved an issue with generating DDL triggers to a script
- Resolved an issue with opening a data report document (D62268, D62249)
2.3.268 29-Jul-21
User-reported and internal bug fixes
- Fixed an issue that occurred when updating Data Editor with server-side sorting/filtering enabled (D55021)
- Fixed an issue that could lead to freezing when executing a function (D59273)
- Resolved an issue that led to SQL document losing focus after execution (D55786)
- Fixed error report on typing in SQL document (D59275)
- Fixed error report on closing SQL Document (D51575)
- Resolved an issue with duplicating columns in Member List (D52937)
- Fixed incorrect text replacing on inserting items from Member List (D53183)
- Fixed false-negative syntax checking (D58703)
- Fixed incorrect date format when exporting to Excel (D59970)
2.3.256 11-Mar-21
User-reported and internal bug fixes
- The application may fail due to stack overflow error when working with specific queries (D50597, D50612)
2.3.255 25-Feb-21
User-reported and internal bug fixes
- The database connection becomes unusable after executing a script with errors (T325239, D48850)
-
Some parts of the workbook require repairing when exporting data to the Excel 2007 format (T318267)
-
Possible critical error when trying to display the loading animation image in specific cases (T317898)
-
The program may fail with a critical error on closing the main window with open documents (T318952)
-
Possible failures when trying to gather quick info for specific code contexts (T319428)
-
When trying to generate DDL scripts for tables with previously dropped columns the program faces the fatal error (T324109)
-
Possible errors when trying to profile queries (T320450)
-
Incorrect code snippets behavior when composing scripts for creation of functions and procedures (T325785)
-
Possible failures when preparing data for the completion list (T320422)
-
In specific cases, the program may fail with the fatal error after opening SQL documents (T320856)
- Trying to run specific queries may hang the client session (T324327)
- The 'Unicode' option is not enabled by default for new connections (T325045, T325280)
- Exporting data to plain text always adds leading whitespaces to the first column (D48683)
- The incorrect quotation behavior when exporting to the CSV format (D48683)
2.3.244 28-Dec-20
Improvements
- Work of the application when connecting via SSL is improved
User-reported and internal bug fixes
- An issue with connecting to IBM Cloud via SSL (T303131, T320717, T319699)
-
An issue with processing Quick Info hints (T319058, T319156, T319659, T319691, T319693, T319988, T320235, T321077, T321261, T321490, T321776, T321918, T322315, T322671, T322705, T321466)
-
Error with data export from multiple tables (T321285)
-
Error with displaying data in FK LookUp editor (T320949)
-
Error with editing data when pressing Space (T317850)
-
The discrepancy between column type and data editor in it (T317850)
-
Treatment of the "REINDEX" keyword as an unexpected symbol (T318951)
-
An option to append a timestamp to a file name is enabled by default (T318267)
-
Error with closing SQL document (T320205, T321175)
-
Error with retrieving data from the compound types based on other compound types (T321077)
- Displaying datatype in the header of Data Editor (T322960)
2.3.237 21-Sep-20
User-reported and internal bug fixes
- The application could fail with a critical error when restoring documents from previous sessions (T316768, T317636)
- An error occurred when trying to view indexes for the columns not available in the database explorer (T316956)
- Incorrect scripts were generated for dropping functions (T316947)
- The execution process for invalid scripts could hang (T317509)
- The application could fail with a critical error when trying to display the quick info (T316765)
- It was impossible to set the TIMESTAMP value to the current date and time Data Editor (T317507)
- An error could occur during snippets storage initialization
- A critical error could occur when launching Query Profiler
2.3.230 31-Aug-20
User-reported and internal bug fixes
- The application failed with a critical error when pressing Backspace immediately after completing a table name (T315942)
- An error occurred while exporting documents or data to '*.docx' format due to missing assembly (T315012)
- Possible fatal error on filtering a completion list (T316045)
- An error that could occur while filling table columns in a completion list (T316070)
- The 'DROP OPERATOR' statement was treated as invalid syntax construction
- Possible failure with a critical error when editing multi-line select script with opened completion list
- The 'IF NOT EXIST' option was treated as invalid syntax when typed after 'ADD COLUMN' clause
- The '[ AND [ NO ] CHAIN ]' options were treated as invalid for the 'ROLLBACK' statement
2.3.212 12-Aug-20
Script Generator Improvements
- Generate Script as DROP and CREATE SEQUENCE
- Generate Script as DROP and CREATE TABLE
- Generate Script as DROP and CREATE for all Source Objects
- Generate Script as CREATE INDEX
SQL Formatter Improvements
- CREATE TRIGGER
- CREATE INDEX
- CREATE SEQUENCE
- CREATE TABLE
- CREATE VIEW
- CREATE MATERIALIZED VIEW
- CREATE PROCEDURE\FUNCTION
Query Profiler Improvements
- Option to view query execution plan without running a query was added
User-reported and internal bug fixes
-
Fatal error caused by the absence of the 'Bezier' skin in the application preferences and which occurred when trying to save options when the skin was active (T293202, T302581, T304084)
- Treatment of the "ILIKE" keyword as an unexpected symbol (T305684)
- Incorrect formatting for TIMESTAMP values was fixed (T298357)
- Critical error occurred when trying to paste empty values to integer fields (T308920)
- The 'syntax error at or near ")"' error message displayed in specific cases when working with indexes (T309366)
- Issue with possibly incorrect quotation handling leading to errors during syntax check and formatting (T308442)
- Critical error occurred due to incorrect command availability handing when trying to copy from query results grid with row numbering enabled (T309718)
- Possible unexpected server response errors (T311429, T306785, T312252)
- Errors that might occur when formatting expressions from executable code fragments (T308582, T313109)
- Possible errors when parsing complex scripts (T310955)
- Critical error occurred when processing extremely large scripts containing the '$$' sequence
-
Critical error the application faced after closing the document in case its text has not been yet supplied
2.2.207 05-Dec-19
User reported bugs fixed
- Problem with edit parameter window is fixed (T298233)
- Problem with data import through Devart ODBC driver for Oracle is fixed (T298292)
- Queries executing with custom parameters issue is fixed (T297883)
- Problem with query profiling on 4K display is fixed (T297789)
- Problems with data selecting from big tables are fixed (T297618, T297610)
2.2.198 12-Nov-19
User reported bugs fixed
- Problem with Query Profiling Mode on High Definition displays is fixed (T297789)
2.2.197 07-Nov-19
User reported bugs fixed
- Problem with query running when Query Profiling Mode is turned on is fixed (T293197)
- Problem with aliases generating is fixed (T296186)
- Problem with foreign key lookup when editing cell in data editor is fixed (T293995)
- Problem with query parameters in sql document is fixed (T293611)
- Problem with sql formatting when NOT EXISTS clause using is fixed (T293445)
2.2.184 01-Oct-19
New features
- Connectivity support for PostgreSQL 12
- Support for Amazon RedShift
- Generate Script AS CREATE for Source Objects
- SQL Code Formatter
- Cached Update mode in Data Eidtor
- Dramatically improved performance of Large Script Execution
- New modern application skins
User reported bugs fixed
- Problems with option Query Profiling Mode are fixed (T282537, T291096)
- Problem with data view in data editor is fixed (T291144)
- Problems with connectinig to server are fixed (T289975, T289283)
- Problem with comments in script is fixed (T281868)
- Problem with incorrect data in Quick Info is fixed (T284615)
- Other user reported bugs are fixed (T282483, T262814, T293121)
2.1.97 06-May-19
New features
- Connectivity Support for Greenplum DB
- Query Profiler functionality
Improved features
- Code Completion
- Database Explorer
- Execute Large Script wizard
User reported bugs fixed
- Problem with connection to database is fixed (T273168)
- Problem with highlighting keywords is fixed (T272218)
- Problem with supporting unicode characters is fixed (T276532)
- Problem with data importing from Excel is fixed (T274766)
- Problem with editing connection category is fixed (T272243)
- Problem with displaying databases is fixed (T252288)
- Other user reported bugs are fixed (T247464, T271986, T271985, T277736)
2.0.111 10-Dec-2018
New features
- Data Export&Import Wizard
- Executed SQL Statements History
- Execute Large Script Wizard
- Master-Detail Browser
- Pivot Table
- SQL Snippets
- Data Reports
SQL Document
- Context prompt in the FROM list of the SELECT queries
- Full code completion support for the SELECT statement
Connectivity
- SSH connection
- Connectivity support for PostgreSQL 11.x
- Connectivity support for PostgreSQL 10.x
- Connectivity support for PostgreSQL 8.3, 8.2, 8.1
- Connectivity support for elephantsql.com
Other Improvements
- Digital signature for the installation file
- FIPS compliance
- The Express Edition will be activated after Standard Edition trial expires
User reported bugs fixed
- Empty field in "Find Result" issue is fixed (T262783)
- Problems with object names in double quotes are fixed (T254981, T254663, T261473)
- Ignore capitalization of tables issue is fixed (T252294)
- Wrong navigation in "Find Results" issue is fixed (T262783)
- Data editing after refresh issue is fixed (T249168)
- Problem with look up using Foreign Key in data grid is fixed (T249168)
- Wrong error output into "Error List" window issue is fixed (T267239)
- Other user reported bugs are fixed (T265265, T262783, T262107, T266337, T246559, T248389, T247982, T249168, T249748, T257319, T256988, T257328, T257784, T257498, T258069, T252101, T248339, T252633, T258491, T244493)
1.0.410 05-Jun-2018
User reported bugs fixed
- Problem with connection to PostgreSQL 10.4 is fixed (T258409)
- Menu item "Retrieve Data" issues are fixed (T255318, T255332, T255583, T256624)
- Problems with double click on a table in the database explorer tree are fixed (T255320, T255441, T255472, T255529, T255572, T255684, T255753, T256393, T256652, T257694, T257665, T257778, T257774, T257825, T257894, T258400, T258674, T258694, T258671)
- Problem with expanding some index in the database explorer tree is fixed (T255319)
- Null Reference Exception issue is fixed (T249168)
- Problem with jsonb value is fixed (T249168)
1.0.381 24-Apr-2018
User reported bugs fixed
- Wrong page after successfully installation issue is fixed (T254732)
- Problems with database name are fixed (T254663, T254981)
- Column value editing issue is fixed (T249168)
- Execute script issue is fixed (T253087)
- Problems with catalogs, temporary schemas and tables display are fixed (T251539, T247102)
- Problem with incorrect format is fixed (T246966)
1.0.344 03-Mar-2018
First release of dbForge Studio for PostgreSQL
© 2024 Devart. All rights reserved.