eMetaDefaultSchemaName support (D2005+): returns "public".

Blob operations are less verbose on the TSQLMonitor.

For better dbExpress™ compliance, the MaxBlobSize parameter now is ignored (but still stored internally).

Fishfact demo updated, and added a D2005 version.

Blob write buffer changed to 4 Kb; it should work with most servers.

Fixed a D2005 bug in the FishFact demo that would prevent quoting of the field names (FishFact's database field names are case sensitive). In fact, this is more a TDatasetProvider bug workaround ( TDatasetProvider.Options.poUseQuoteChar is initialized as False).

Fixed a bug where a wrong license would give a "65535" error message instead of "Invalid license...".

Fixed timestamp fields inserting/updating.

Enhanced PostgreSQL 8.0 support.

Delphi 8 and 9 support.

Asynchronous connections support. This allows cancelling queries in execution. See more on Section 4.10, "Canceling a query".

libpq updated to v8.01.

New standard-based translation system: gettext. This will allow anyone to make it's own translation, contribute a translation, or even modify existing ones.

Added multiple transactions support (PostgreSQL 8+)

The traditional PGEDemo demo now has two versions: CLX and VCL.

Internal code cleanup and rearrangement.

Now pgExpress reads the actual object's name size from the server (ISQLMedata.eMetaMaxObjectNameLength option). This will allow the pgExpress Driver to adjust itself better to custom builds of the server where the the NAME fields are not default (64 chars).

New key/registration system.

Fixed ServerDecimalSeparator issue with localized servers, specially those which use "," as decimal separator.

Fixed a bug in PostgreSQL bytea fields (VarBytes/Bytes field): it was missing the 2 bytes length specifier at the beginning of the stream.

Fixed TimeStampTz fields issue with locales that use "," as decimal separator.

Fixed ISQLMetadata.Getprocedures method to be more schema-friendly.

New demo: StoredProcs. Demonstrates how to use a Stored Procedure (PostgreSQL Function) with pgExpress.

BLOBs documentation seriously revised. Take a look on the new documentation and way to create the 'lo' type.

FishFact demo updated.

Some bugs on the Large Objects (BLOBs) interface/type mapping have been fixed. Fixed also the trigger and cleanup function.

Fixed another bug in the Fetch Cursors interface.

A new Special param, LogDeclareFetch, allows to filter the internal DECLARE/FETCH commands executed by the pgExpress Driver when using Fetch Cursors.

Compiled with Delphi v7.1. This Delphi version has several updates on the dbExpress™ and TClientDataset areas and is highly recommended to everyone developing using Delphi.

libpq upgraded to v7.4.3.

Enhanced documentation again.

On PostgreSQL 7.4+, the automatic DECLARE/FETCH interface was revised and should be working on all situations. Cursors now are closed correctly on all situations and the "cursor pgeCursor already declared" error message which could appear on PostgreSQL v7.4+ is fixed, since the cursors now will have an unique name.

Updated support to PostgreSQL v7.4.

Smarter libpq handling and locating, specially under Kylix.

The libpq library was updated to version 7.41. SSL dependency was dropped since not everyone had SSL installed. Users that want SSL suport should provide a SSL enabled libpq.

Varchar fields (with no size specifier) are now mapped to VCL/CLX  Memo fields, since they behave exactly like TEXT fields.

Internal enhancements make the metadata faster and use less memory.

Enhanced documentation/FAQ.

With the PostgreSQL v7.4 support, a new notice processor was introduced. The NOTICE messages generated by the server will not have the "NOTICE: " prefix anymore. If someone wants the old behavior for some reason, please mail us and we might be adding a special param for this.

Also, "ERROR:" will not be inserted before error messages anymore.

Fixed a StoredProc bug that would prevent some functions to be found/run successfully

Fixed "Connection Timeout" D7 param (do not confuse with pgExpress ConnectionTimeout special param).

Fixed a bug in the GetColumns() interface.

Support for NOTICEs and warnings from the server, on the TSQLMonitor. These messages will be logged automatically now. More details here.

The ErrorResourceFile parameter now allows loading an specific language by default.

New Sequences demo that demonstrates uses of sequences (or any other server-generated values).

New Console demo that demonstrates how to use pgExpress from a console mode application.

Enhanced money type detection; should work on more locales now.

More documentation formats: html-chunked (default), HTMLHelp (.chm file) and html (single file).

Two new utility functions: SetLanguage and GetLanguage that work with the multilanguage driver.

The formar Multilanguage distribution has been dropped due to the introduction of the Multilanguage Driver. Now both drivers, English and Multilanguage (which includes all languages including English itself) are available on all pgExpress distribution packages.

Now htmlhelp is the primary documentation format for the install (Windows only) version.

Updated libpq library to v7.3.3.

Updated documentation and FAQ.

Enhanced driver logs (those monitored by TSQLMonitor). Among other things, now the PostgreSQL libpq and pgExpress Driver version numbers/paths are logged (some info is available only under Windows). The pgExpress Driver also logs its build time now. This should help debugging.

Fixed a bug that could lead to slow updates /connect times on the Delphi version of the driver.

Console apps now should work better under Kylix, not requiring XLib™ to be present.

PostgreSQL 7.3 is supported. All the metadata interfaces have been thoroughly revised to support introduction of Schemas. You can even retrieve metadata with fully qualified names.

BLOB writing support. Please refer to the Section 4.7, "Large Objects (BLOBs)" section for more details.

Native support to int8 (Int64/bigint) type. Now this is the default for int8 fields; users that want old behavior (which is typecasting Int8 as BCD numbers) can force its use through the use of the Int8Mode special parameter. Many thanks for Peter Sawatzki (http://www.sawatzki.de) for pointing out the hack.

With PostgreSQL 7.3, schemas are now supported through use of the RoleName parameter. Just use something as:

RoleName = public, a, b

to set the RoleName.

Support for Custom Parameters on Delphi 7. The Custom String parameter can be used to set the Special Params (please see docs for details).

Driver more compatible with Delphi 7. The following ISQLConnection.getOption() values are interpreted:

These options bring also better schema support.

Support for functions that return multiple rows (PostgreSQL 7.3 and above).

New Special Parameter: RetainCursor. Will retain the cursor for the previous SELECT statement. This will avoid the same query to be run twice for non-cached datasets. This an experimental switch and should not be used by all users. Please read the docs.

Support for the ServerPort parameter. Will work the same way it does for the Borland PostgreSQL driver. It allows to specify the port number to connect to. This setting is available from D7

New Special Parameter: UseQualifiedNames (for PostgreSQL 7.3+). Will show qualified names (Schema + '.' + ObjectName) for metadata objects. Default: False.

New Special Parameter: RestrictedNameSpace (for PostgreSQL 7.3+). It controls how the metadata is retrieved. If RestrictedNameSpace is True, only objects in the current namespace search path will be retrieved. If False, all objects will be retrieved, regardless of which namespace they are in.

New Special Parameter: RequireSSL. Will only connect to the server in SSL mode. Currently will work only under Kylix with SSL compiled libpq (Windows libpq can't be compiled with SSL).

New Special Parameter: ConnectionTimeout (needs libpq 7.3 and above; included with distribution). Allows to specify connection timeouts (in seconds). On Delphi 7, the regular driver parameter [Connection Timeout] can also be used.

New Special Parameter: AutoRecover. Will automatically try to recover the connection if it gets broken. Registered users only.

New pgeDriverUtils.pas unit, with easy to use wrappers for retrieving information from the pgExpress Driver using the new Custom Info Parameters.

New Custom Info: TTY - allows setting file or TTY for optional debug output from the backend.

New Custom Info: BackendPID (read only). Will retrieve the PID of the process of the connection in the backend server.

Support for the eConnOnline ISQLConnection.getOption() interface (D7+ only). Will return True if the driver is properly connected to the server, False if not. See the pgeDriverUtils unit for example usage.

New Special Param: ShowOID. Will show OID (if existent) as a field on the table, when quering metadata (ISQLCursor.getFields()).

The following driver languages are now available:

Documentation completely revamped. Now DocBook™ is used to keep the documentation. The HTML, HTML (Chunked) and HTML Help formats are available.

New libpq library, from PostgreSQL v7.32, added to the distribution.

With the introduction of the hack that allows native use of Int8 fields, the AsInt8 parameter becomes obsolete. Please check Native Int8 support for more details.

Code cleanup.

Now, objects (Tables, field names, etc.) with spaces or other non-standard characters will be quoted automatically even if the QuoteObjects special param is not in use. D7+ only.

With the extra D7 dbExpress™ API implementation, the "parse error" messages trying to use

CommandType = ctTable

should be gone (D7 specific bug).

Solved bug loading pgExpress from DLLs/OCXs/etc. Now it should be ok to use pgExpress from a ISAPI DLL, for instance.

The FETCH cursors were not logging the additional FETCH commands into the TSQLMonitor as they should (according to the docs), but just the first one.

Fixed bug on string parameters that were already quoted.

New custom setting: FetchCursor. Allows one to use automatically DECLARE/FETCH cursors. Rows will be retrieved on demand. For registered users only.

Localized Drivers support. Now pgExpress support the following languages:

More languages to come...

New custom setting: ServerDecimalSeparator. Will allow to force a decimal separator char on the server. This should not be necessary, however, since pgExpress is able to find out the correct chars automatically.

New demo: Params. A simple demonstration of use of Params with pgExpress.

Updated documentation.

Updated PGEDemo. Now it should be more portable to Delphi 7.

Updated installer (Windows version only).

The packages version of the driver has been dropped.

Fixed bug for some types of prepared queries.

Fixed "not under Delphi" issues

Fixed PostgreSQL loss of precision when using functions on numeric values returned by functions suchs as:

select max(my_numeric_field) from test;

Major new version.

Delphi 7 support. The driver should work with Delphi 7 now. Some of the small new features of dbExpress™ introduced on Delphi 7 and Kylix 3 will be supported in the next version.

New custom setting: QuoteObjects. Setting this option to True will make the pgExpress quote object names (fields, tables, etc.). Some users needed it to port SQL queries from phppgadin™, for instance. More info on the documentation.

New custom setting: GetExtendedFiledInformation. This setting will get extended information about the fields in a dataset; more specifically, get it will allow to check if a field is AutoIncrement or is Nullable. Please check the docs for more information.

New custom setting: TypesCachingMode. This setting controls how often the PostgreSQL types are (re)mapped into dbExpress™ VCL/CLX  types.

Unsafe SQL parameters and now properly escaped (using libpq's PQescapeString() function).

Docs enhanced.

New libpq included. This should fix the Multibyte problems that some users have been having.

Better support for foreign locales (those using ',' as decimal separator).

Installer enhancements (on Windows platform).

Several small internal optimizations and support for the forthcoming pgExpress Suite.

The registration procedure is changed. The old way (Registry keys) lead to some portability issues. The new way makes it much easier to deploy your applications and don't requires anything special to be done on the target machines.

Now PostgreSQL TEXT fields will be mapped to Memo (BLOB) fields by default. This will make grids faster, reduce memory requirements and it does make more sense after all.

Changed some messages that will appear on the TSQLMonitor components.

The custom parameters on the dbxdrivers(.ini) file are now obsolete and not supported anymore. They can remain there but will be ignored. Please query the documentation for the new way of passing parameters using the Database parameter setting (in the Special Params section).

The ISQLMetadata.getColumns() interface is enhanced and will provide much more accurate information to TSQLDataset. SetSchemaInfo(stColumns, '', '') calls.

An INSERT/UPDATE/DELETE bug exception could occur when updating to NULL values. This is fixed now.

The ISQLMetadata.GetProcedureParams() was not working properly due to some internal changes whose were needed for our upcoming product: the pgExpress Suite. Now the Stored Procedures (emulated through functions) parameters are automatically filled again.

The MaxBlobSize parameter was not being considered for text fields mapped as TMemoField.