Softpedia >Windows >Internet >Servers >Database Utils >dbForge Studio Express for PostgreSQL >  Changelog

dbForge Studio Express for PostgreSQL Changelog

What's new in dbForge Studio Express for PostgreSQL 3.1.839

Jan 18, 2024
  • Fixed an error that occurs when switching between Card View and Grid View in the Data Editor.

New in dbForge Studio Express for PostgreSQL 3.1.832 (Jan 10, 2024)

  • 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

New in dbForge Studio Express for PostgreSQL 3.1.789 (Nov 27, 2023)

  • 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

New in dbForge Studio Express for PostgreSQL 3.1.696 (Aug 16, 2023)

  • Added support for PostgreSQL 16

New in dbForge Studio Express for PostgreSQL 3.1.618 (May 24, 2023)

  • Connectivity:
  • Added connectivity 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)

New in dbForge Studio Express for PostgreSQL 3.0.472 (Jan 30, 2023)

  • 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 connectivity support for PostgreSQL 15
  • Extended support for high-DPI devices
  • Improved the behavior of the Retrieve Data feature
  • Added connectivity support for AWS Babelfish
  • Added connectivity support for YugabyteDB
  • Added connectivity support for Neon.tech
  • Added connectivity support for Digitalocean Managed Databases
  • Added connectivity support for CitusData
  • Added connectivity support for ApsaraDB
  • Added connectivity support for PolarDB
  • Added connectivity support for AnalyticDB
  • Added connectivity 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

New in dbForge Studio Express for PostgreSQL 2.3.287 (Nov 22, 2022)

  • Fixed PostgreSQL connection issues.
  • Fixed several minor errors.

New in dbForge Studio Express for PostgreSQL 2.3.285 (Jul 15, 2022)

  • Fixed compatibility issues with the latest Windows 11 updates (D84717,D85016,D90557)

New in dbForge Studio Express for PostgreSQL 2.3.280 (May 21, 2022)

  • 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)

New in dbForge Studio Express for PostgreSQL 2.3.278 (Oct 20, 2021)

  • 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

New in dbForge Studio Express for PostgreSQL 2.3.273 (Aug 13, 2021)

  • Resolved an issue with generating DDL triggers to a script
  • Resolved an issue with opening a data report document (Z62268, Z62249)

New in dbForge Studio Express for PostgreSQL 2.3.268 (Jul 30, 2021)

  • Fixed an issue that occurred when updating Data Editor with server-side sorting/filtering enabled (Z55021)
  • Fixed an issue that could lead to freezing when executing a function (Z59273)
  • Resolved an issue that led to SQL document losing focus after execution (Z55786)
  • Fixed error report on typing in SQL document (Z59275)
  • Fixed error report on closing SQL Document (Z51575)
  • Resolved an issue with duplicating columns in Member List (Z52937)
  • Fixed incorrect text replacing on inserting items from Member List (Z53183)
  • Fixed false-negative syntax checking (Z58703)
  • Fixed incorrect date format when exporting to Excel (Z59970)

New in dbForge Studio Express for PostgreSQL 2.3.256 (Mar 12, 2021)

  • The application may fail due to stack overflow error when working with specific queries (Z50597, Z50612)

New in dbForge Studio Express for PostgreSQL 2.3.255 (Feb 25, 2021)

  • User-reported and internal bug fixes:
  • The database connection becomes unusable after executing a script with errors (Т325239, Z48850)
  • 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 (Z48683)
  • The incorrect quotation behavior when exporting to the CSV format (Z48683)

New in dbForge Studio Express for PostgreSQL 2.3.244 (Dec 28, 2020)

  • 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, T320225, T321077, T321261, T321490, T321776, T321918, T322315, T322671, T322705, Т321466)
  • 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)

New in dbForge Studio Express for PostgreSQL 2.3.237 (Sep 21, 2020)

  • 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

New in dbForge Studio Express for PostgreSQL 2.3.230 (Aug 31, 2020)

  • 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

New in dbForge Studio Express for PostgreSQL 2.3.212 (Aug 12, 2020)

  • 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 PROCEDUREFUNCTION
  • 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

New in dbForge Studio Express for PostgreSQL 2.2.207 (Dec 5, 2019)

  • 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)

New in dbForge Studio Express for PostgreSQL 2.2.198 (Nov 12, 2019)

  • User reported bugs fixed:
  • Problem with Query Profiling Mode on High Definition displays is fixed (T297789)

New in dbForge Studio Express for PostgreSQL 2.2.197 (Nov 8, 2019)

  • 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)

New in dbForge Studio Express for PostgreSQL 2.2.184 (Oct 1, 2019)

  • New features:
  • Connectivity support for PostgreSQL 12
  • Support for Amazone 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)

New in dbForge Studio Express for PostgreSQL 2.1.97 (May 6, 2019)

  • 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)

New in dbForge Studio Express for PostgreSQL 2.0.111 (Dec 10, 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)

New in dbForge Studio Express for PostgreSQL 1.0.410 (Jun 5, 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 (T255319)
  • Null Reference Exception issue is fixed (T249168)
  • Problem with jsonb value is fixed (T249168)

New in dbForge Studio Express for PostgreSQL 1.0.381 (Apr 24, 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)