PostgresDAC 2.5.5 beta available

This beta introduces the latest 8.4.3 libraries, improvements for user-defined types support, savepoint functionality support, new behaviour options for TPSQLDataset descendants and several bug fixes.

You’re welcome to download the PostgresDAC v2.5.5-beta Trial right now.

Or login to your private area on our site to obtain Full version.


PostgresDAC 2.5.4 released

Ability to set error messages verbosity added. PostgreSQL v8.4.2 client libraries added (including pg_dump & pg_restore).

Full changelog:
[!] TPSQLDatabase.ErrorVerbosity property added
[!] v8.4.2 client libraries added
[!] v8.4.2 dump & restore libraries (pg_dump.dll, pg_restore.dll)
[+] TPSQLDataset descendants support TField.OldValue from now
[+] v8.2.14 dump & restore libraries (pg_dump-8.2.14.dll, pg_restore-8.2.14.dll) added
[*] Support of еnumerated (enum) types improved
[*] Thread safety improved inside low level conversion routines
[*] UTF8 support for versions lower then Delphi 2009 improved
[-] “EConvertError exception occurs rarely when TPSQLDatabase.CommandTimeout changed” bug fixed
[-] “Invalid Pointer Operation in TPSQLTable.IndexDefs.Update” bug fixed
[-] “Missing quotes for BYTEA parameters sent to server” bug fixed
[-] AV in TPSQLQuery.SetParamsFromCursor eliminated

There are both Trial and Full versions of installer of PostgresDAC v2.5.4 available.

You’re welcome to download the PostgresDAC v2.5.4 right now at,
or login to your private area on our site at

Please don’t hesitate to ask any questions or report bugs with our Support Ticketing system available at

PostgreSQL client libraries update

We (in MicroOLAP Technologies) just finished client libraries update for 8.4.1 version.

Quick facts:

  • Two packages were updated:
    • Deployment libraries shipped with PostgreSQL installation
    • Deployment libraries built with MinGW environment
  • Both packages are built against 8.4.1 version of PostgreSQL
  • Comparing to 8.3.6 version libpq.dll library shipped with PostgreSQL installation depends on 12 libraries now (were 9 in 8.3.6)
  • Dump and restore libraries for 8.3.x and 8.2.x PostgreSQL branches are included into “Deployment libraries built with MinGW environment” package
  • Included dump libraries (pg_dump-8.2.14.dll, pg_dump-8.3.8.dll) may be used with PaGoDump utility either


Building PostgreSQL 8.0.x using MinGW under Win… Magician wanted

Compiling the fresh PostgreSQL releases is not a problem under Windows using MinGW as you probably know.

One of my clients asked me to build pg_dump\pg_restore if it’s possible of course. Yes, I know that 8.0.x and 8.1.x branches are not supported anymore. At least officially. I was just curious.

Well, I spent a day making compiler happy. I built the client library libpq.dll, but dump and restore utilities are beyond my power.

The last words were:

pg_backup_archiver.o:pg_backup_archiver.c:(.text+0x43a): undefined reference to `__’
collect2: ld returned 1 exit status
make: *** [pg_dump] Error 1

Possibly my changes caused this. Since I’m not so familiar with GCC universe I’m still confused about it. Gurus’ advices appreciated.

And the last but not least. Is there any chance that MinGW compatibility patches for 8.0.x and 8.1.x branches will be committed officially?


PS Kids don’t do drugs!

Client libraries for PostgreSQL 8.4.0 update

Since PostgreSQL 8.4.0 has been released, MicroOLAP updated deployment libraries (libpq.dll and dependencies) on the company site.

So, those who need only client libraries for applications deployment can obtain them from PostgresDAC Download page.

There are two archives:

  • Deployment libraries shipped with PostgreSQL 8.4.0 installation
  • Deployment libraries built with MinGW environment

The first one doesn’t need an explanation. Details on the second could be found in my previous post.


MinGW & BCC patches applied!

Thanks to the PostgreSQL community, part of which I definitely am :), Tom Lane applied patches against 8.4 branch that fix problems with MinGW and BCC described in my previous posts:

So, my first patches (approved and edited by Tom I suppose) are applied! Kudos!

Archive entries:

Building PostgreSQL client library using Borland C++ Compiler (BCC) under WinXP


We already know how to build client library for PostgreSQL using MinGW from my previous post.

Today we’re going to play with Borland C++ Compiler (which is free by the way). Some people might find this very useful. Actually it was fun, for me it was some kind of a puzzle.

Continue reading “Building PostgreSQL client library using Borland C++ Compiler (BCC) under WinXP”