Softpedia >Windows >Programming >Other Programming Files >PostgresDAC >  Changelog

PostgresDAC Changelog

What's new in PostgresDAC 3.12.0

Jan 18, 2022
  • v14.1 client libraries added
  • v14.1 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • v14.1 MSVC x64 client libraries added
  • OpenSSL 1.1.1m support added
  • TestDoubledColons unit test case for TPSQLQuery added
  • "PSQLTypes.hpp conflicts with minwinbase.h for Win32 target" bug fixed
  • Conditional directives for Windows fixed
  • TPSQLNotify payload processing fixed for x64 platform

New in PostgresDAC 3.11.0 (Oct 9, 2021)

  • RAD Studio 11 Alexandria (Delphi and C++ Builder) support introduced
  • v14 client libraries added
  • v14 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • TPSQLDump will warn if postfix operators are being dumped

New in PostgresDAC 3.10.0 (Jul 17, 2021)

  • Full changelog:
  • V13.3 client libraries added
  • V13.3 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • OpenSSL 1.1.1k support added
  • Ensure that TPSQLDump collects per-column information about extension configuration tables
  • Ensure that the restore script runs ALTER INDEX ATTACH PARTITION commands as the owner of the partitioned index
  • Ensure that the restore script runs ALTER PUBLICATION ADD TABLE commands as the owner of the publication
  • Remove warnings in unit tests
  • Report the correct database name in connection failure error messages from TPSDQLDump and TPSQLRestore
  • Fix missed file version check in TPSQLRestore
  • Fix TPSQLDump to handle WITH GRANT OPTION in an extension's initial privileges
  • Fix TPSQLDump's dumping of generated columns in partitioned tables
  • Fix TPSQLDump's dumping of inherited generated columns

New in PostgresDAC 3.9.0 (Sep 25, 2020)

  • v13 client libraries added
  • v13 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • TPSQLTable.HasOIDs property removed as obsolete
  • Fix foCaseInsensitive in TPSQLDataset.Filter

New in PostgresDAC 3.8.0 (Jul 15, 2020)

  • RAD Studio 10.4 Tokyo (Delphi and C++ Builder) support introduced

New in PostgresDAC 3.7.0 (Oct 23, 2019)

  • This release introduces support for the new PostgreSQL 12 major version.
  • V12 client libraries added
  • V12 dump & restore libraries (pg_dump.dll, pg_restore.dll) added

New in PostgresDAC 3.6.0 (Jul 23, 2019)

  • V11.4 client libraries added
  • V11.4 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • DoLoadViaPartitionRoot option added to TPSQLDump.Options
  • DoNoComments option added to TPSQLDump.Options

New in PostgresDAC 3.5.0 (Apr 3, 2019)

  • New installer introduced
  • RAD Studio 10.3 Tokyo (Delphi and C++ Builder) support introduced
  • TPSQQLQuery.BeforeExecSQL event added
  • "NUMERIC caused AV in Delphi 6" bug fixed

New in PostgresDAC 3.4.6 (Sep 5, 2018)

  • Change log:
  • v10.5 client libraries added
  • v10.5 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • Fixed TPSQLDump's failure to dump REPLICA IDENTITY properties for constraint indexes
  • Fixed handling of some cases where TPSQLDatabase.Host address is specified

New in PostgresDAC 3.4.5 (Jun 6, 2018)

  • v10.4 client libraries added
  • v10.4 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • HotLibrarySwitch function added to PSQLTypes
  • Avoid use of insecure search_path settings in TPSQLDump
  • libpq's memory consumption reduced when a server error is reported after a large amount of query output has been collected
  • Incorrect TPSQLDump output for some non-default sequence limit values fixed
  • TPSQLDump's mishandling of STATISTICS objects fixed

New in PostgresDAC 3.4.4 (Mar 2, 2018)

  • PostgresDAC 3.4.4 fixes installation error for RAD Sudio 10.2.
  • You do not need to update if you not using RAD Studio 10.2 version.

New in PostgresDAC 3.4.3 (Feb 15, 2018)

  • v10.2 client libraries added
  • v10.2 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • Fix TPSQLDump to make ACL, comment, and security label entries reliably identifiable in archive output formats
  • "Components inactive on RAD Studio 10.2.2 palette for some platforms" bug fixed

New in PostgresDAC 3.4.2 (Jan 11, 2018)

  • "TPSQLQuery.ExecSQL may produce incorrect TPSQLQuery.RowsAffected property value" bug fixed

New in PostgresDAC 3.4.1 (Dec 12, 2017)

  • Dump & restore libraries updated (9.3.20, 9.4.15, 9.5.10, 9.6.6)
  • "TPSQLDump.OnLog ignored for some libraries" bug fixed

New in PostgresDAC 3.4.0 (Nov 30, 2017)

  • v10.1 client libraries added
  • v10.1 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • Lazarus 1.6.4 support introduced
  • OpenSSL 1.1.0g support added
  • Improved ARC support for NEXTGEN compilers
  • dsoNumericAsFloat option added to TPSQLDataset options
  • "TPSQLDatabase.KeepConnection set to False may leave active connections on Android" bug fixed

New in PostgresDAC 3.3.0 (Oct 19, 2017)

  • v10.0 client libraries added
  • v10.0 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • PostgresDAC components are enabled on IDE Component pallette for all platforms from now
  • doNoPublications option added to TPSQLDump.Options
  • doNoSubscriptions option added to TPSQLDump.Options
  • doNoSync option added to TPSQLDump.Options
  • roNoPublications option added to TPSQLRestore.Options
  • roNoSubscriptions option added to TPSQLRestore.Options
  • Crash fixed in TPSQLRestore when using parallel mode and using a list file to select a subset of items

New in PostgresDAC 3.2.4 (Aug 30, 2017)

  • [!] v9.6.4 client libraries added
  • [!] v9.6.4 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • [+] doNoBlobs option added to TPSQLDump.Options
  • [+] TPSQLDatabase.GUC[Name: string]: string property added
  • [+] TPSQLDatabase.ReloadGUC method added
  • [+] TPSQLRestore.ExcludeSchemas property added
  • [*] Improved TPSQLDump/TPSQLRestore's reporting of error conditions originating in zlib
  • [*] Support for TFmtBCDField (NUMERIC) fields with TClientDataset improved
  • [*] TPSQLDirectQuery supports NULL parameters from now
  • [*] TPSQLDump and TPSQLRestore will emit REFRESH MATERIALIZED VIEW commands last
  • [-] TPSQLDump will not emit invalid SQL for an empty operator class
  • [-] TPSQLDump with the doClean option drops event triggers as expected now
  • [-] TPSQLDump with the doClean option will not fail when the public schema doesn't exist
  • [-] "EConvertError during timeout for SSH connection" bug fixed

New in PostgresDAC 3.2.3 (May 16, 2017)

  • [!] v9.6.3 client libraries added
  • [!] v9.6.3 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • [+] EPSQLDatabaseError message now uses native SQL state codes for PostgreSQL specific errors
  • [+] TFmtBcdField parameters support added to TPSQLUpdateSQL
  • [*] Creating duplicated parameters for TPSQLQuery.Params is prevented
  • [*] Implicit type casting added to prevent AV bugs in 64-bit compilers
  • [-] "Incorrect schema and owner marking for comments and security labels of some types of database objects in PTSQLDump" fixed
  • [-] Some additional checks added for C++ Builder installer
  • [-] TPSQLDump and TPSQLRestore correctly handle privileges for the public schema for doCleanroClean options
  • [-] Typo in TPSQLDump's query for initial privileges of a procedural language fixed

New in PostgresDAC 3.2.2 (Apr 7, 2017)

  • [!] RAD Studio 10.2 Tokyo (Delphi and C++ Builder) support introduced
  • [!] Linux target platform support added
  • [*] Additional check added for TPSQLDatabase global list existence in finalization

New in PostgresDAC 3.2.1 (Dec 27, 2016)

  • [!] v9.6.1 client libraries added
  • [!] v9.6.1 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • [+] TPSQLDatabase.LibraryVersionAsInt property added
  • [-] Fixed the "End of table" error which appeared after Refresh call for empty result sets

New in PostgresDAC 3.2.0 (Dec 27, 2016)

  • [!] Android target platform support added
  • [!] v9.6.0 client libraries added
  • [!] v9.6.0 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • [!] NUMERIC fields are mapped to TFmtBcdField from now
  • [+] TPSQLRestore.SchemaNames property introduced to specify multiple schemas
  • [+] doStrictNames option added to TPSQLDump.Options
  • [+] roStrictNames option added to TPSQLRestore.Options
  • [*] TPSQLRestore.TableNames property to match all types of relations, not only plain tables
  • [*] In TPSQLDump locally-made changes in privilege assignments for system objects
  • [*] TPSQLRestore.SchemaName property removed as deprecated, use SchemaNames instead
  • [-] Assigning MEMO fields to empty string may cause memory leak

New in PostgresDAC 3.1.3 (Dec 27, 2016)

  • [*] Local positioning improved for TPSQLQuery with RequestLive after Post
  • [-] Work with NULL values fixed in dsoRefreshModifiedRecordOnly mode

New in PostgresDAC 3.1.2 (Dec 27, 2016)

  • [!] Support for RAD Studio 10.1 Berlin (Delphi and C++ Builder) introduced
  • [!] Support for Lazarus 1.6.0 added
  • [!] Support for FreePascal 3.0.0 added
  • [+] Ctrl+A functionality added to TPSQLQuery edit form

New in PostgresDAC 3.1.1 (Dec 27, 2016)

  • [!] v9.5.1 client libraries added
  • [!] v9.5.1 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • [*] Avoid dump/reload problems when using both plpython2 and plpython3
  • [*] Make TPSDump mark a view's triggers to be processed after its rule, to prevent possible failure during parallel restore
  • [-] "Improper quoting of domain constraint names in TPSQLDump" bug fixed
  • [-] "TPSQLTable.FindKey fails for two-column unicode varchar index" bug fixed
  • [-] Assorted corner-case bugs in TPSQLDump's processing of extension member objects fixed

New in PostgresDAC 3.1.0 (Dec 27, 2016)

  • [!] v9.5.0 client libraries added
  • [!] v9.5.0 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • [+] "EPSQLDatabaseError.ErrrorXXX properties contain old values in some scenarios" bug fixed
  • [+] doEnableRowSecurity option introduced for TPSQLDump.Options property
  • [+] doIfExists option introduced for TPSQLDump.Options property
  • [+] roEnableRowSecurity option introduced for TPSQLRestore.Options property
  • [+] roIfExists option introduced for TPSQLRestore.Options property
  • [+] TestSSLConnect case added for TPSQLDatabase unit test
  • [+] tiSERIALIZABLE option added for TPSQLDatabase.TransIsolation property value
  • [+] TPgSSHDatabase.AddSSHKeyToSystemCache property added
  • [+] TPgSSHDatabase.ShowPLinkConsole property added
  • [+] TPSQLDatabase.Assign implemented
  • [+] TPSQLDump.Snapshot property introduced
  • [*] More informative message introduced for TPgSSHDatabase connection errors
  • [*] PSQLMetadata unit excluded as deprecated
  • [*] TPSQLStoredProc.RefreshParams now throws exception if connection error occurred
  • [-] "Error code in TPSQLDatabase.StartTransaction ignored" bug fixed

New in PostgresDAC 3.0.4 (Dec 27, 2016)

  • [!] TPgSSHDatabase supports plink.exe binary for creating tunnel from now
  • [!] v9.4.5 client libraries added
  • [!] v9.4.5 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • [*] libpq's handling of out-of-memory conditions improved
  • [*] More informative error message introduced if login prompt absent
  • [*] Support for shell types (not fully defined) to TPSQLDump added
  • [*] Temporary files created during a TPSQLDump run with tar-format output are not world-readable now
  • [*] TPSQLDump handles inherited NOT VALID check constraints correctly
  • [*] TPSQLDump handles object privileges sanely when dumping from a server too old to have a particular privilege type
  • [*] TPSQLDump supports cases where the postgres or template1 database is in a non-default tablespace
  • [*] Unit PSQLGeomTypes implicitly included into package warning eliminated for pre-Delphi12 compilers
  • [*] Win64 platform added to RAD Studio 10 Seattle package
  • [-] "Setting bookmark on the last row may corrupt result set after reopening dataset" bug fixed
  • [-] Assorted minor memory leaks in TPSQLDump fixed
  • [-] EIntOverflow error eliminated if dsoUseGUIDField included in dataset options
  • [-] Selection of default zlib compression level in TPSQLDump's directory output format fixed

New in PostgresDAC 3.0.3 (Dec 27, 2016)

  • [!] Package for RX10 Seattle added
  • [-] Incompatibilities of C++ Builder and geometrical types fixed
  • [-] "Not a valid timestamp error when using ClientDataset/AppServer" bug fixed
  • [-] "Underscore in stored routine name is treated as wildcard symbol and break Overload property value" bug fixedmetrical types fixed.

New in PostgresDAC 3.0.2 (Dec 27, 2016)

  • [!] v9.4.2 client libraries added
  • [!] v9.4.2 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • [!] v9.3.7 dump & restore libraries (pg_dump-9.3.7.dll, pg_restore-9.3.7.dll) added
  • [!] v9.2.11 dump & restore libraries (pg_dump-9.2.11.dll, pg_restore-9.2.11.dll) added
  • [+] TPSQLCopy.SaveToStrings(Strings: TStrings; Encoding: TEncoding) method added
  • [*] Dumping of views that are just VALUES(...) but have column aliases improved
  • [*] Possible TPSQLDump failure when concurrent sessions are creating and dropping temporary functions avoided
  • [*] Risk of network deadlock when using non-blocking mode reduced
  • [*] Scroll bars added to SQL Editor if standard memo used
  • [*] TPSQLDump considers foreign key relationships between extension configuration tables while choosing dump order
  • [*] TPSQLDump now honors CompressLevel value together with dfDirectory output format
  • [-] TPSQLDump's rule for deciding which casts are system-provided casts that should not be dumped fixed

New in PostgresDAC 3.0.0 (Dec 27, 2016)

  • [!] Fetch-On-Demand mode introduced for readonly TPSQLQuery objects
  • [!] Support for geometric types added
  • [!] TPSQLRangeField added
  • [!] Support for pre-8.0 PostgreSQL servers is discontinued
  • [!] v9.4.0 client libraries added
  • [!] v9.4.0 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • [*] Components TPSQLUser and TBDE2PSQLDAC marked as deprecated and will be removed shortly
  • [*] EPSQLDatabaseError is raised if TPSQLDatabase is used in non-exclusive mode for TPSQLQuery with dsoFetchOnDemand
  • [*] TPSQLDatabase.CancelBackend checks for connection now to prevent AV
  • [-] "AV may occur if SQL parameter name consists from incorrect characters chain" bug fixed
  • [-] "EPSQLDatabaseError detail error properties are empty after error in TPSQLDirectQuery.Open" bug fixed

New in PostgresDAC 2.12.1 (Aug 7, 2014)

  • v9.2.9 dump & restore libraries (pg_dump-9.2.9.dll, pg_restore-9.2.9.dll) added
  • v9.3.5 client libraries added
  • v9.3.5 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • Client library without SSL support (libpq-without-SSL.dll, x86 only) added
  • BDE dependency removed for Delphi 5 packages
  • Indentation in rule/view dumps reduced to improve readability and avoid excessive whitespace
  • Installation incompatibilities for RAD Studio XE6 solved
  • Delphi XE7 Carpathia packages added for testing
  • Buffer bloat in libpq avoided when the server consistently sends data faster than the client can absorb it
  • Dumping of rules/views when subsequent addition of a column has resulted in multiple columns matching a USING specific fixed
  • Fixed TPSQLDump to cope with a materialized view that depends on a table's primary key
  • TPSQLRestore's processing of old-style large object comments fixed

New in PostgresDAC 2.12.0 (May 2, 2014)

  • PostgresDAC v2.12.0 with support for Delphi XE6 and C++ Builder XE6

New in PostgresDAC 2.11.2 (Mar 26, 2014)

  • v9.3.4 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • v9.3.4 client libraries added (x86 and x64 platforms)
  • v9.2.8 dump & restore libraries (pg_dump-9.2.8.dll, pg_restore-9.2.8.dll) added
  • "TPSQLStoredProc.RefreshParams doesn't fill parameters if Overload property is not 0" bug fixed

New in PostgresDAC 2.11.1 (Jan 16, 2014)

  • TPSQLCopy.LoadFromProgram method added
  • TPSQLCopy.SaveToProgram method added
  • "ftMemo values with one byte client_encoding (not UTF8) are broken" bug fixed
  • Bug with dump causing by environment settings is fixed

New in PostgresDAC 2.11.0 (Nov 21, 2013)

  • v9.3.1 client libraries added (x86 and x64 platforms)
  • v9.3.1 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • TPQSQLDump supports Directory output format from now
  • TPQSQLDump supports parallel processing
  • v9.2.5 dump & restore libraries (pg_dump-9.2.5.dll, pg_restore-9.2.5.dll) added
  • doNoSynchronizedSnapshots option added to TPSQLDump.Options
  • roNoSecurityLabels option added to TPSQLRestore.Options
  • TPSQLDump.ExcludeTablesData property added
  • TPSQLDump.Jobs property added
  • TPSQLDump.Sections property added
  • TPSQLRestore.SchemaName property added
  • TPSQLRestore.Sections property added
  • TPSQLRestore.TableNames property added
  • Make TPSQLDump put SEQUENCE SET items in the data not pre-data section of the archive
  • Support for old dump and restore libraries is discontinued (v8.x, v9.1)
  • tar files emitted by TPSQLDump are POSIX conformant now
  • TPSQLDump excludes data of unlogged tables when running on a hot-standby server
  • TPSQLDump outputs functions in a more predictable order
  • TPSQLRestore now accepts POSIX-conformant tar files
  • Fixed bugs in the restore.sql script emitted byTPSQLDump in tar output format
  • Fixed TPSQLDump for views with circular dependencies and no relation options
  • Fixed TPSQLDump's handling of DROP DATABASE commands if doClean option specified

New in PostgresDAC 2.10.0 (Sep 27, 2013)

  • Delphi XE5 and C++ Builder XE5 support introduced
  • PostgreSQL 9.3 support added
  • OpenSSL 1.0.1e libraries added
  • EPSQLDatabaseError.ErrorSchemaName property added
  • EPSQLDatabaseError.ErrorTableName property added
  • EPSQLDatabaseError.ErrorColumnName property added
  • EPSQLDatabaseError.ErrorDatatypeName property added
  • EPSQLDatabaseError.ErroConstraintName property added
  • "Filtering DataTime field not working in early versions Delphi" bug fixed

New in PostgresDAC 2.9.7 (Aug 26, 2013)

  • Syntax highlighting introduced for Query SQL Editor if SynEdit installed
  • Caching the values of a multi-column lookup field now allowed
  • coFREEZE option added to TPSQLCopy.Options property
  • Connect\Disconnect items added to TPSQLDatabase's popup menu
  • Open\Close items added to TPSQLQuery's popup menu
  • EPGLibraryNotFoundException class removed
  • TPSQLDataset.Lookup rewritten from scratch
  • "Cannot perform operation on the open database error during converting old projects" bug fixed
  • "EAccessViolation raised instead of OS exception in design time during library load" bug fixed

New in PostgresDAC 2.9.6 (May 14, 2013)

  • Delphi XE4 and C++ Builder XE4 support

New in PostgresDAC 2.9.5 (Apr 18, 2013)

  • Support for Lazarus in design time introduced
  • Critical bug with reading TMemoField.AsString in Delphi XE3 which causes rare unpredictable AV's eliminated

New in PostgresDAC 2.9.4 (Mar 14, 2013)

  • TDateTimeField supports dates before 30/12/1899 from now
  • Handling of empty BLOB query parameters improved
  • Improved support for field values with round number of milliseconds
  • Obtaining size of Large Objects (oid) accelerated
  • "Calculated field overrides the value of the first field in the dataset in XE3" bug fixed
  • "Cannot set 00:00:00.0 value for TIME field, only 24:00:00.0 allowed" bug fixed
  • "Cannot set EncodeDate(1899, 12, 30) value for DATE field" bug fixed
  • Ambiguity between Sysutils::UIntToStr and Psqltypes::UIntToStr resolved in XE2

New in PostgresDAC 2.9.3 (Feb 18, 2013)

  • v9.2.3 client libraries added
  • "FieldDef.Required always false" bug fixed
  • "Incorrect work Locate and Lookup functions with filtered records" bug fixed
  • "Reading TPSQLDatabase.Host IP-address from .dfm may fail if host name was assigned earlier" bug fixed
  • "TPSQLNotify may produce rare memory corruption if USE_THREAD_POLLING firective used" bug fixed
  • Ambiguity between System::Sysutils::UIntToStr and Psqltypes::UIntToStr resolved

New in PostgresDAC 2.9.2 (Dec 26, 2012)

  • Design time packages are not dependent on BDE rtl anymore
  • Support for Delphi Starter edition added
  • PgSSHDatabase packages for RAD Studio XE3 added
  • "Invalid typecast error when compiling package for Win64 target" bug fixed
  • "Reading BLOB fields in Delphi XE3 may produce Access Violation or Stack Overflow error" bug fixed

New in PostgresDAC 2.9.1 (Nov 21, 2012)

  • v9.2.1 client libraries added
  • v9.2.1 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • "GetBookmark and GotoBookmark moves cursor to the first row in RAD Studio XE3" bug fixed
  • "TPSQLDataset.Locate method fails for loCaseInsensitive option" bug fixed
  • "TPSQLDataset.Locate method fails for loPartialKey option" bug fixed
  • "TPSQLDataSet.SortBy may fail on some result sets" bug fixed

New in PostgresDAC 2.9.0 (Nov 1, 2012)

  • v9.2.0 client libraries added
  • v9.2.0 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • New field data processing methods introduced for Delphi XE3
  • Support for IProviderSupportNG interface introduced in RAD Studio XE3 added
  • TParam.DataType property for function argument with domain type is set to base type of domain instead of ftString
  • "E2015 Ambiguity between TDataSet::PSExecuteStatement and TPSQLDataset::PSExecuteStatement in C++ Builder XE3" bug fixed
  • "ftDate and ftTime fields may produce memory corruption in Delphi XE3" bug fixed
  • "TPSQLDataset.Locate method fails for timestamp fields"bug fixed
  • Internal memory leaks of EPSQLException objects eliminated
  • Memory leaks in TPSQLUpdateSQL's BLOBs processing are eliminated

New in PostgresDAC 2.8.3 (Aug 30, 2012)

  • v9.1.5 client libraries added
  • v9.1.5 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • TPSQLDataset.RecordSize property type changed to Integer
  • TPSQLDump better handle views containing partial GROUP BY lists from now
  • TPSQLNotify.OnNotify events are executed in the main thread context from now
  • "Can't install FastReport engine if QBuilder is installed" bug fixed
  • "PSQLNotify stops sometimes if XE2 used because of QueryPerformanceCounter fluctuations" bug fixed
  • "Range check error occurs sometimes for result sets with many columns" bug fixed

New in PostgresDAC 2.8.2 (May 26, 2012)

  • v9.1.3 client libraries added
  • v9.1.3 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • Connection library ignores ENOTDIR errors when looking for an SSL client certificate file
  • TPSQLDump's handling of inherited table columns improved
  • Arbitrary limitation on length of common name in SSL certificates removed
  • Compression of plain-text output format in TPSQLDump fixed
  • Contents of an extension's configuration tables aren't dumped if the extension itself is not being dumped
  • Fix TPSQLDump to dump user-defined casts between auto-generated types, such as table rowtypes
  • Missed quoting of foreign server names in TPSQLDump fixed
  • Newlines are converted to spaces in names written in TPSQLDump comments
  • Platform-specific infinite loop in TPSQLDump avoided

New in PostgresDAC 2.8.1 (May 26, 2012)

  • Incompatibilities with C++Builder personality for Windows target platform eliminated
  • FastReport engine packages for Delphi XE2 added
  • Oid constants added for range types and JSON (PG9.2)

New in PostgresDAC 2.8.0 (Mar 14, 2012)

  • FireMonkey and cross platform support improved a lot
  • Support for custom connection parameters added to TPSQLDatabase.Params
  • EPGLibraryNotFoundException class introduced
  • TPSQLDatabase.OnException event added
  • TPSQLDatabase.Ping method added
  • TPSQLDatabase.UseSingleLineConnInfo property added
  • TPSQLNotify polling loop rewritten using threads
  • Handling of "libpq library not found" exception improved
  • Nag trial screen removed
  • OS GUI dependencies eliminated. Console application creating improved a lot
  • "XE and higner applications hang on close if TPSQLMonitor used" bug fixed

New in PostgresDAC 2.7.0 (Nov 15, 2011)

  • Support for RAD Studio XE2 added
  • v9.1.0 dump & restore libraries (pg_dump.dll, pg_restore.dll)
  • DB engine for FastReport added
  • "TPSQLDump ignores TPSQLDatabase.Params on connection" bug fixed
  • Ability to convert MySQLDAC components by TBDE2PSQLDAC added
  • ConvertComponents property added to TBDE2PSQL migration component
  • dfDirectory format added to TPSQLDump
  • SourceConnection property added to TBDE2PSQL migration component
  • TPSQLDump doNoSecurityLabels option added to exclude security labels from dump
  • TPSQLDump doNoUnloggedTableData option added to exclude contents of unlogged tables from the dump
  • TPSQLDump doQuoteAllIdentifiers option added to force quoting of all identifiers
  • TPSQLDump doSerializableDeferrable option added to use a serializable transaction for the dump
  • TPSQLNotify.SendNotify supports Payload parameter
  • TPSQLNotify.UnlistenAll method added
  • v9.1.0 client libraries added
  • XE2 SSH packages added

New in PostgresDAC 2.6.4 (Jul 15, 2011)

  • dsoRefreshModifiedRecordOnly option added to TPSQLDatasetOptions
  • TPSQLCopy.DataFormat property added
  • TPSQLCopy.Encoding property added
  • TPSQLTools.Execute(Operation: TPSQLOperation) method overloaded added
  • Error handling improved for TPSQLTools class

New in PostgresDAC 2.3.5 (Sep 16, 2006)

  • Latest v8.1.4 PostgreSQL sources (pg_dump.c and pg_restore.c) used for libraries creation
  • Improved index fetching for TPSQLTable component
  • SEEK_SET, SEEK_CUR, SEEK_END are redefined in BCB code
  • Dump and restore functionality rewritten from scratch. Libraries pg_dump.dll and pg_restore.dll added. See "Deploy.txt" for details
  • Functions added to TPSQLDump class: - procedure DumpToStream(Stream: TStream; Log: TStrings); overload; - procedure DumpToStream(Stream: TStream; LogFileName: string); overload; - procedure DumpToFile(const FileName, LogFileName: string); overload
  • Function added to TPSQLRestore class: - procedure RestoreFromFile(const FileName, LogFileName: string); overload
  • "Can't update fields containing long strings through TPSQLUpdateSQL" bug fixed
  • "Floating memory problems using strings longer then 256 characters" bug fixed
  • TAutoIncField critical bug fix: default values for integer fields were fetched incorrectly
  • "CanModify property was always True for TPSQLQuery with RequestLive = True" bug fixed
  • "Error when open BYTEA field with content greater then 65Kb" bug fixed
  • "CBuilder error: E2109 Not an allowed type in PSQLAccess.hpp" bug fixed
  • Fixed: TBDE2PSQL doesn't work for D6 and higher in TDatamodule
  • Fixed: Memory Leak in PGDump
  • Fixed: TPSQLQuery.Params[Index].AsTime doesn't work