PostgreSQL Data Access Components (PgDAC) Releases

Released: Feb 19, 2024

Updates in 8.1.0

Funktionen

  • Added support for Lazarus 3.0.
  • Improved working with column default values.
  • Improved working with RefreshRecord queries.
  • Improved working with arrays in queries.

Fehlerkorrekturen

  • Fixed bug with "Current transaction is aborted, commands ignored until end of transaction block.".
  • Fixed bug with "Multiple transactions are not supported by the database.".
  • Fixed bug with "date/time field value out of range" for IDE12 Win64 target platform.

Released: Nov 15, 2023

Updates in 8.0.0

Funktionen

  • Added support for Embarcadero RAD Studio 12 Athens.
  • Added support for PostgreSQL 16.
  • Added support for Apple macOS Sonoma.
  • Added support for Apple iOS 17.
  • Added support for Android 13.
  • Added support for PREPARE/EXECUTE commands.
  • Added support for nested macros in SQL queries.
  • Added Display Format for Aggregate fields.
  • Added support for SHA-2 (SHA-256, SHA-512) in hash encryption algorithms.

Fehlerkorrekturen

  • Fixed bug with "SSL function is not linked. You should update the SSL client...

Released: Mar 17, 2023

Updates in 7.4.0

Funktionen

  • Added support for Embarcadero RAD Studio 11 Alexandria Release 3.
  • Added support for Apple iOS Simulator target platform.
  • Added support for Lazarus 2.2.6.
  • Added support for PostgreSQL 15.
  • Added support for YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, GETDATE, DATE, TIME, TRIM, TRIMLEFT, TRIMRIGHT statements in TDADataSet.Filter.
  • Added support for mathematical operations in TDADataSet.Filter.
  • Added support for Aggregate Fields and InternalCalc Fields.
  • Added the ability to restore from file...

Released: Sep 12, 2022

Updates in 7.3.0

Funktionen

  • Added support for Embarcadero RAD Studio 11 Alexandria Release 2.
  • Added support for Lazarus 2.2.2.
  • Added support for Apple iOS 15.
  • Added support for Android 12.
  • Added support for PostGIS.
  • Query and Table components add 'CloneCursor' method which allows you to share data between datasets.
  • Improved 'TimeZoneOffset' support for 'TPgTimeStamp'.
  • Improved 'Truncate' method in 'TPgLargeObject' class.
  • Improved performance when exporting to XML.

Fehlerkorrekturen

  • Fixed bug with executing a...

Released: Apr 12, 2022

Updates in 7.2.1

Funktionen

  • Added support for Embarcadero RAD Studio 11.1 Alexandria.
  • Added support for Lazarus 2.2.0.
  • Added support for Microsoft Windows 11.
  • Added support for Apple macOS Monterey.
  • Added support for SCRAM-SHA-256-PLUS authentication mechanism.
  • Added support for 'ON CONFLICT' in batch operations.
  • Improved open connection performance.
  • Added 'AddDelete 'property to Dump component.
  • Added the ability to dump stored procedures using the Dump component.

Fehlerkorrekturen

  • Fixed bug with saving JSON...

Released: Dec 9, 2021

Updates in 7.1.1

Funktionen

  • Added support for PostgreSQL 14.
  • Added stored procedure OUT parameters in PostgreSQL 14.
  • Added PoolId connection option.

Fehlerkorrekturen

  • Fixed bug with Access Violation on RefreshRecord after connection switching.
  • Fixed bug with application name when connection pooling is used.
  • Fixed bug with using "ON CONFLICT DO NOTHING" in batch operations.
  • Fixed bug with processing large OID values.
  • Fixed bug with freezing multiply connection pools in threads.
  • Fixed bug with using the AsDate...

Released: Sep 13, 2021

Updates in 7.0.1

Funktionen

  • Added support for Embarcadero RAD Studio 11 Alexandria.
  • Added support for Apple macOS ARM.
  • Added a demo project for FastReport FMX.

Fehlerkorrekturen

  • Fixed bug with processing UUID fields.
  • Fixed bug with processing large OID values.
  • Fixed bug with the incorrect encoding of error messages.
  • Fixed bug with the incorrect RowsAffected result of the WITH ... statement.
  • Fixed bug with error when setting the "0" value for a currency field.
  • Fixed bug with automatic conversion of null values...

Released: Jul 14, 2021

Updates in 6.4.4

Funktionen

  • Added support for TFieldOptions.

Fehlerkorrekturen

  • Fixed bug with executing a stored procedure when ProtocolVersion = pvAuto.
  • Fixed bug with executing a "SELECT FROM ..." statement.
  • Fixed bug with a "Range check error" exception when executing a statement with parameters.
  • Fixed bug with AV when executing a "SET ROLE ..." statement.
  • Fixed bug with updating a table that has a Serial field.
  • Fixed bug with handling statement parameters of the ftUnknown data type.
  • Fixed bug with applying...

Released: Apr 6, 2021

Updates in 6.4.3

Fehlerkorrekturen

  • Demo compatibility with new a version of SecureBridge has been fixed.
  • Fixed bug with reading date value "2000-01-01" when the EnablePgTimestamps option is set to True.
  • Fixed bug with reading server messages.

Released: Mar 26, 2021

Updates in 6.4.2

Funktionen

  • Added support for Lazarus 2.0.12.

Fehlerkorrekturen

  • Fixed several bugs with the MultipleConnection option.
  • Fixed several bugs with ProtocolVersion = pvAuto.
  • Fixed a bug with AV when opening a form containing a SQL component.
  • Fixed a bug with LockMode = lmPessimistic.
  • Fixed a bug with the ConvertEOL connection option.
  • Fixed a bug with AV in applications using DBMonitor.
  • Fixed a bug with committing a transaction when LockMode = lmPessimistic.
  • Fixed a bug with getting values of...