2. Changelog

This section lists changes history of the pgExpress Driver.

If you have doubts or need support, please write us at support@vitavoom.com.

Version 4.60 - Release Date: 18 Mar 2013
New release.
ADDED

Support for PostgreSQL 9.2.

ADDED

Support for the JSON type (new on PostgreSQL v9.2). Will be mapped as TEXT.

ADDED

Documentation enhancements.

CHANGED

The libpq library is not provided anymore. It was an obsoleted version. Please install the latest PostgreSQL 32 bits distribution for your platform and use the libpq from it. Please check also Section 1.1, “Libpq”.

Version 4.50 - Release Date: 27 Mar 2012
New release.
ADDED

Support for PostgreSQL 9.1.

Version 4.40 - Release Date: 02 Oct 2010
New release.
ADDED

Support for PostgreSQL 9.0.

Version 4.31 - Release Date: 08 Jan 2010
New release.
ADDED

Support for PostgreSQL 8.4.

Version 4.30 - Release Date: 22 Oct 2008
Bugfix release.
ADDED

Support for PostgreSQL's 8.3 UUID fields.

ADDED

Documentation enhancements.

ADDED

Enhanced multithreading functionality.

CHANGED

OID fields will always be mapped as int4. Please check OID type for details.

FIXED

Fixed GetProcedureParams() interface, what fixes store procedures usage under IDE.

FIXED

Fixed RoleName parameter under protocol 4.0 (Delphi 2007+).

FIXED

Fixed timestamp millisecond bug.

Version 4.23 - Release Date: 07 May 2008
Bugfix release.
FIXED

Small bugfixes.

Version 4.22 - Release Date: 01 Apr 2008
Bugfix release.
FIXED

Fixed access violations in some particular situations.

FIXED

Fixed issues with timestamp fields under Delphi 2007.

Version 4.21 - Release Date: 23 Mar 2008
Bugfix release.
FIXED

Fixed random memory error / "Read of address FEEEFEEE in module 'libpq.dll'" messages.

Version 4.20 - Release Date: 06 Feb 2008
New major version.
ADDED

PostgreSQL 8.3 support. XML fields will be mapped the same way TEXT fields are, i.e. as Blob/Memo; Section 4, “Types Mappping” for details.

ADDED

Enhanced Delphi 2007+ support (dbExpress4 support). Please see Installation on dbExpress 4.0 protocol (Delphi 2007+) for details. With that feature comes also new DBX4Compatible special param.

ADDED

Now the pgExpress Driver can generate large log messages (> 1024 bytes) (log messages can be captured by TSQLMonitor instances).

ADDED

Documentation enhancements.

FIXED

pgExpress won't refuse to work with 8.2.6 (or later) versions anymore.

Version 4.11 - Release Date: 04 Apr 2007
Bugfix release.
ADDED

Documentation enhancements.

FIXED

Fixed size of GRAPHIC blobs

FIXED

Fixed PostgreSQL's version rounding bug caused by a RoundTo() bug.

Version 4.10 - Release Date: 06 Dec 2006
Maintenance release.
ADDED

Preliminar PostgreSQL v8.2 support. Please read the version-specific notes.

FIXED

Fixed a couple OUT parameters Stored Procedures problems.

FIXED

Fixed a problem in the GetProcedureParams interface.

FIXED

Documentation fixes.

Version 4.05 - Release Date: 16 Oct 2006
Maintenance release.
ADDED

Documentation enhancements.

FIXED

Fixed a bug retrieving Stored Procedure names.

FIXED

Fixed escaped characters in memo fields.

FIXED

Fixed include in pgeDriverUtils.pas.

FIXED

Fixed numeric without precision/scale, such as:

create table test(a numeric));
FIXED

Fixed some bugs on the automatic Fetch Cursors interfaces

Version 4.04 - Release Date: 01 Jun 2006
Maintenance release.
ADDED

Support for the EnterpriseDB.

FIXED

Int8Mode could be ignored on certain systems.

Version 4.03 - Release Date: 25 Apr 2006
Bugfix release.
ADDED

Documentation enhancements.

FIXED

Fixed a bug on Memo fields with protocol 3.0 drivers (garbage at the end of the field).

FIXED

Fixed a problem with stored procedure parameters introduced on the 4.x series.

FIXED

Fixed a problem with empty string parameters under Kylix.

FIXED

Added a workaorund for a PostgreSQL parser bug where floats are not recognized if not quoted (ex: update mytable where myfloat = 1.00)

FIXED

Some small bugfixes.

Version 4.02 - Release Date: 06 Mar 2006
Bugfix release.
ADDED

Added support for the VCL/CLX "Trim Char" parameter.

FIXED

Fixed a bug with string parameters on protocol v3.0 drivers.

FIXED

Fixed a bug on virtual cursor interfaces that could cause problems on the GetColumnNames() interface in and stored procedures.

FIXED

Fixed a bug with blob (bytea) parameters.

Version 4.01 - Release Date: 27 Jan 2006
Bugfix release.
FIXED

Fixed a couple bugs in the 4.00 version.

Version 4.00 - Release Date: 26 Jan 2006
New major version: BDS 2006 and UNICODE support.
ADDED

Added BDS 2006 compatibility. This includes support for protocol v3.0, unicode interfaces, native int64, enhanced dbExpress™ API. pgExpress is the first driver to add such support.

ADDED

Enhanced UNICODE support. Check also the UnicodeAsWideChar parameter. If you have problems opening bases with UNICODE encoding, add a client encoding to your dbxconnections(.ini) entry, such as:

ServerCharset = /latin1

For more details, please refer to Section 1, “Multibyte, UNICODE and Locales”.

ADDED

With the introduction of protocol 3.0 support in BDS 2006, now we have two new drivers, dbexpge30.dll and dbexpge30-ml.dll, whose implement it. These drivers will work only on BDS 2006 and later. The regular pgExpress Driver which implements dbExpress™ protocol 2.5 still works with BDS 2006, but pgExpress protocol 3.0 won't work with applications built for older protocol implementations.

ADDED

Added UnicodeAsWideChar special param: will map char/varchar fields as TWideString fields. This will work only if the client encoding is UNICODE, and with protocol 3.0 or above.

ADDED

Added BorlandCompatible special param, which adds more compatility between pgExpress and Codegear drivers, on the NUMERIC mapping.

ADDED

Documentation enhancements.

ADDED

The following new interfaces are supported:

  • eConnConnectionString
  • eConnPrepareSQL
  • eConnDecimalSeparator
  • eConnEncrypted
  • eConnMultipleTransaction
  • eCommCursorName

Most of these interfaces will only be recognized on BDS 2006 please check your IDE documentation for more details.

ADDED

The libpq library was updated to version 8.1.2, for both Linux and Windows.

CHANGED

Now if the client encoding is UNICODE and the application does not support that encoding (all compiled with compilers before BDS 2006), or do not user UnicodeAsWideChar, the pgExpress Driver will automatically set the client encoding to LATIN-1. While it should fit most users, it can be easily changed to any desired encoding value by using the ServerCharset parameter.

FIXED

Fixed a bug where the ByteaMode Special Param would not be recognized on all situations.

FIXED

Fixed libpq dependencies on comerr32.dll and other external libraries.

FIXED

Fixed libpq loading under Win9X.

FIXED

Fixed a licence bug on Windows.

Note

Older versions information has been ommited to keep this document cleaner.