PostgreSQL v9.0.0 client libraries update

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

Quick facts:

  • Two packages were updated:
    • Deployment libraries shipped with PostgreSQL installation
    • Deployment libraries built with MinGW environment
  • Both packages are built against 9.0.0 version of PostgreSQL
  • Dump and restore libraries for 8.4.x, 8.3.x and 8.2.x PostgreSQL branches are included into “Deployment libraries built with MinGW environment” package
  • Included dump and restore libraries (pg_dump-x.x.x.dll, pg_restore-x.x.x.dll) may be used with PaGoDump and PaGoRestore utilities respectively.

Have a nice day!

PostgresDAC 2.5.5 released

This release 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.

Full changelog:
[!] v8.4.3 client libraries added
[!] v8.4.3 dump & restore libraries (pg_dump.dll, pg_restore.dll)
[+] v8.2.16 and v8.3.10 dump & restore libraries (pg_dump_8.x.x.dll, pg_restore_8.x.x.dll)
[+] dsoEmptyCharAsNull option added to TPSQLDataaset.Options property
[+] dsoUDTAsMaxString option added to TPSQLDataaset.Options property
[+] Methods Savepoint, ReleaseSavepoint, RollbackToSavepoint added to TPSQLDatabase
[+] Some unit tests added for RAD Studio 2010
[*] Current record position preserved after changing index or performing local sort
[*] Improved processing for NAME, TIME WITH TIMEZONE, TIMESTAMP WITH TIMEZONE field types
[*] Improved support for network address types (inet, cidr, macaddr)
[*] Improved support for user-defined types with OIDs greater then 65535
[*] Prevent “:” character followed by non-printable character in TPSQLQuery.SQL to be treated as parameter
[*] Prevented index info fetching for non-table datasets
[*] Thread safety improved for date\time low level conversion routines
[*] TPSQLStoredProc.Overload is set to 0 if StoredProcName were changed from now
[*] UTF8 encoding is not performed for connection parameters in IDE’s prior to Delphi 2009
[*] XML type mapped to TMemoField from now
[-] “Cannot obtain parameters from server if TPSQLStoredProc.Overload differs from default value” bug fixed
[-] “In IDE versions prior to 2009 using UTF-8 client encoding corrupts data display” bug fixed
[-] “Range methods (SetRange, SetRangeStart, SetRangeEnd) may fail on string values if UTF8 used” bug fixed
[-] “TPSQLDatabase.SelectString doesn’t return aDefaultValue if aFieldNumber less then zero” bug fixed
[-] “TPSQLTable.Options change have no effect” bug fixed
[-] “Wrong time value passed to server in some system date and time regional options, e.g. Italian” bug fixed
[-] Unwanted Assert() call eliminated in TPSQLDataset.Lookup method

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

You’re welcome to download the PostgresDAC v2.5.5 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/

Please don’t hesitate to ask any questions or report bugs with our Support Ticketing system available at
http://www.microolap.com/support/

PostgreSQL v8.4.3 client libraries update

We (in MicroOLAP Technologies) just finished client libraries update for 8.4.3 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.3 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.16.dll, pg_dump-8.3.10.dll) may be used with PaGoDump utility either

Enjoy!

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
http://microolap.com/products/connectivity/postgresdac/download/,
or login to your private area on our site at
http://microolap.com/my/downloads/

Please don’t hesitate to ask any questions or report bugs with our Support Ticketing system available at
http://www.microolap.com/support/

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

Enjoy!

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?

Regards

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.

Regards.