PostgresDAC 3.1.3 is released


The MicroOLAP team is proud to announce the release of PostgresDAC v3.1.3 which fixes a bug for dsoRefreshModifiedRecordOnly mode and improves positioning after Post for some queries.

PostgresDAC v3.1.3 is mostly maintenance release.

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

You’re welcome to download the PostgresDAC v3.1.3 right now at:
http://microolap.com/products/connectivity/postgresdac/download/
or login to your private area on our site at
http://microolap.com/my/downloads/

PostgresDAC meets RAD Studio 10.1 Berlin!

PostgresDAC v3.1.2 with support for RAD Studio 10.1 Berlin (both Delphi and C++ Builder), Lazarus 1.6 and FreePascal 3.x is available immediately!

Full change log:
[!] 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 for TPSQLQuery edit form

You’re welcome to download the PostgresDAC v3.1.2 right now at:
http://microolap.com/products/connectivity/postgresdac/download/
or login to your private area on our site at
http://microolap.com/my/downloads/

PostgresDAC 3.1.1 is out


The MicroOLAP team is proud to announce the release of PostgresDAC v3.1.1 which updates client libraries used and fixes some rare bugs.

PostgresDAC v3.1.1 is mostly maintenance release. Most notably this release fixes errors with TPSQLDump and TPSQLRestore components.

Full change log:
[!] 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

You’re welcome to download the PostgresDAC v3.1.1 right now at:
http://microolap.com/products/connectivity/postgresdac/download/
or login to your private area on our site at
http://microolap.com/my/downloads/

PostgresDAC 3.1.0 meets PostgreSQL 9.5!

Support for PostgreSQL 9.5 added.

Full change log:
[!] 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

You’re welcome to download the PostgresDAC v3.1.0 right now at:
http://microolap.com/products/connectivity/postgresdac/download/
or login to your private area on our site at
http://microolap.com/my/downloads/

PostgresDAC 3.0.4 is immediately available


The MicroOLAP team is proud to announce the release of PostgresDAC v3.0.4. This release introduces support for latest PostgreSQL version, extends payload by adding new TPgSSHDatabase implementation, improves dump and restore machinery, fixes all known bugs.

Full change log:
[!] 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

You’re welcome to download the PostgresDAC v3.0.4 right now at:
http://microolap.com/products/connectivity/postgresdac/download/
or login to your private area on our site at
http://microolap.com/my/downloads/

PostgresDAC 3.0.3 meets RAD Studio 10 Seattle!

Full changelog:

[!] 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.

You’re welcome to download the latest release right now at:
http://microolap.com/products/connectivity/postgresdac/download/
or login to your private area on our site at
http://microolap.com/my/downloads/

PostgresDAC 3.0.2 with PostgreSQL 9.4.2 support is available


The MicroOLAP team is proud to announce the release of PostgresDAC v3.0.2 with support for PostgreSQL 9.4.2.

Full change log:
[!] 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

You’re welcome to download the PostgresDAC v3.0.2 right now at:
http://microolap.com/products/connectivity/postgresdac/download/
or login to your private area on our site at
http://microolap.com/my/downloads/