PostgreSQL Data Access Components

3.1.4 28-Dec-11

Reading the Bytes data type as Hex is supported
The UniqueFieldIndexSeparator global variable is added
Bug with assertion failure at proccesing the cached data is fixed
Bug with Delphi IDE hanging at closing in case of using DBMonitor is fixed
Bug with freeing memory in Lazarus is fixed
Several bugs with 64-bit application development are fixed
Several bugs in design-time editors are fixed

3.1.3 23-Nov-11

Update 2 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
Mac OS X and iOS in RAD Studio XE2 is supported
FireMonkey support is improved
Lazarus 0.9.30.2 and FPC 2.4.4 are supported
Mac OS X in Lazarus is supported
Linux x64 in Lazarus is supported
FreeBSD in Lazarus is supported
PostgreSQL 9.1 is supported
Bug with time zone for time and timestamp data types is fixed
Bug with PgDump with PostgreSQL 8.2 is fixed
Bug with memory leak in TDALoader is fixed
Problem with receiving DateTime parameter for DBMonitor in Delphi 2009 and higher is fixed

3.0.2 10-Oct-11

Bug with compilation for Linux in Lazarus is fixed
Bug with multiple default schemas definition is fixed
Bug with the WsaData global variable in threads is fixed
Bug with Unicode password is fixed

3.0.1 15-Sep-11

Embarcadero RAD Studio XE2 is supported
Application development for 64-bit Windows is supported
FireMonkey application development platform is supported
Support of master/detail relationship for TVirtualTable is added
OnProgress event in TVirtualTable is added
TDADataSetOptions.SetEmptyStrToNull property that allows inserting NULL value instead of empty string is added
Problem with working in the pooling mode is fixed
Bug with SQL query following an empty SQL query is fixed

2.20.0.8 19-Jul-11

Bug with getting ServerList is fixed
Bug with assertion failure on using master/detail relationship with TClientDataset is fixed
Bug in TCustomDADataSet.PSGetKeyFields method when persistent fields are created in dataset is fixed

2.20.0.7 15-Jun-11

Possibility to load data in TVirtualTable without recreating persistent fields is added
Working in design time editor of the TVirtualTable component is improved
Loading files opened by other applications is improved
Support of case sensitive procedures is improved
Support of overload procedures is improved
Bug with processing key fields on record posting is fixed
Bug with using protocol version 2 is fixed
Several bugs with design-time editors for Lazarus are fixed

2.20.0.6 28-Apr-11

Lazarus 0.9.30 and FPC 2.4.2 is supported
Application Name connection option is supported
Payload parameter for PostgreSQL notification is supported (TPgNotificationEvent changed: EventMessage parameter is added)
Bug with parsing SQL that contains escape sequences is fixed
Bug with showing backup progress is fixed
Bug in bookmark validity check is fixed

2.10.0.5 10-Mar-11

Delphi & C++Builder XE Starter Edition supported
Fixed registration procedure of Borland SQL Monitor when TUniSQLMonitor is created at runtime
Fixed bug in PgDump with growing of memory usage
Fixed bug with queries inside transaction (cursor PORTALSTxxxxxx already exists)

2.10.0.4 26-Jan-11

Improved performance
Fixed bug with triggers backup in TPgDump
Fixed bug with FetchAll=False

2.00.0.3 08-Dec-10

Improved performance of INSERT, UPDATE, DELETE, and SELECT queries that return few records
Added calling the BeforeExecute event for the Open and Refresh dataset operations.
Fixed sorting order for columns that contain NULL values if sort is defined by the IndexFieldNames property
Fixed the Detail dataset refreshing (for Master-Detail datasets) after connection loss in the LocalFailover mode
Fixed bug with refreshing record for Master-Detail datasets

2.00.0.2 04-Nov-10

PostgreSQL 9.0 supported
Added case sensitive schema name
Added checking that dataset is open on calling the TDataSet.Locate method
Improved table names detecting inside SQL queries for the UpdatingTable property
Fixed bug with error on functions backup
Fixed bug with error on database with case sensitive name backup
Fixed bug with table or view names that contain single quotes (for example, 'name')

2.00.0.1 13-Sep-10

Embarcadero RAD Studio XE suppored
Added the UUID data type support. Now the UUID data type is represented by the TGuidField field.
Fixed bug with filling default expression for fields in the design mode for inactive dataset
Fixed bug with the LIKE keyword in the TDataSet.Filter property

1.20.0.19 13-Aug-10

Changed the LocateEx method behavior: now LocateEx centers records equal to Locate
Added the OnBeforeExecute event
Fixed bug with reopening TPgQuery in the UniDirectional mode after PostgreSQL database error.
Fixed bug with RefreshRecord and numbers with floating point
Fixed bug in Migration Wizard with converting units in the UTF8 and UTF16 encoding

1.20.0.18 24-Jun-10

Added ability to lock records in the CachedUpdate mode
Added overloaded declaration of the ApplyUpdates method to choose update kind
Fixed bug with quote that first character inside quoted string for the Filter property
Fixed bug in TCRBatchMove with processing RecordCount

1.20.0.17 26-May-10

Updated compatibility with other DAC components

1.20.0.16 09-Apr-10

Added support of ONLY lexeme in the FROM statement
Fixed bug with comparing Date field values on optimistic locking
Fixed bug in the AddWhere, DeleteWhere, SetOrderBy, and GetOrderBy methods for Tables
Fixed bug with calculating RecNo in CachedUpdates mode

1.20.0.15 04-Mar-10

Added ability to send call stack information to the dbMonitor component
Fixed bug with refreshing record when using master/detail relationship
Fixed bug with LocalUpdate in the CachedUpdates mode
Fixed bug with DBMonitor for C++ Builder 6

1.20.0.14 26-Jan-10

Added OnStart, OnCommit, OnRollback events to TDATransaction
Fixed problem with using TLargeintField in master/detail
Fixed bug with refreshing record when RefreshOptions.roBeforeEdit is set and LockMode = lmPessimistic
Fixed bug with setting EOF when FetchAll=False

1.20.0.13 01-Dec-09

Added support for dbMonitor 3
Added CursorWithHold option for TCustomPgDataSet to use FetchAll=False mode without transaction
Fixed bug with updating table, that has field name, representing a valid hexadecimal number
Fixed bug with updating field value with preceding spaces when TrimFixedChar or TrimVarChar = True
Fixed bug with executing large file in UTF-8 format

1.20.0.12 12-Nov-09

Now Required flag is set for UpdatingTable fields only
Fixed bug with detecting parameter size for MBCS strings
Fixed problem with detecting slash with text after it as a delimiter in TDAScript
Fixed bug with SetOrderBy and SetWhere when there is no space before ORDER or WHERE
Fixed bug with executing large file in Unicode format
Fixed the "Cannot convert type" error in Trial version

1.20.0.11 13-Oct-09

Now the AssignConnect method copies transaction state
Fixed bug with locating records using the LocateEx method and the lxNearest option
Fixed bug with AV failure in MemData
Fixed bug with SQL Generator in design-time
Fixed problem with help registration under RAD Studio 2010
Fixed problem with loading DataSet Manager under RAD Studio 2010

1.20.0.10 10-Sep-09

Embarcadero RAD Studio 2010 suppored
Now the subdetail is refreshed before the AfterRefresh event of the detail is called
ConnectionTimeout is now used when resolving the host name

1.10.0.9 01-Sep-09

Added support for automatic starting a transaction when FetchAll=False
Added FullRefresh option for TCustomPgDataSet
Now the value from the master dataset has priority over the DefaultExpression value
Fixed bug with not unlocking record in the CachedUpdates mode if no fields were changed
Fixed bug with parsing TDAScript.Statements
Fixed bug with FetchAll=False and inline comment at the end of SQL

1.10.0.7 24-Jun-09

Fixed bug with local sorting in CachedUpdates mode
Fixed bug with raising exceptions on locating records when IndexFieldNames is set
Fixed bug with calculating connection count in Disconnected mode
Fixed bug with calling the OnError event on connection failure when Pooling is enabled
Fixed bug with macros in TDAScript
Fixed incorrect authentification and disconnect messages that cause errors in the server log
Fixed bug with restoring after the error on operations with large object

1.10.0.6 27-May-09

Added the Disconnected property to TCustomDADataSet
Added distinction between empty string and null value when saving/loading string fields in TVirtualTable
Added the UseParamTypes option used to disable automatic detection of parameter types
Fixed bug with the GotoCurrent method
Fixed bug with LocalMasterDetail and Prepare method
Fixed bug with FullRefresh and macros
Fixed bug with string fields longer than 65535
Fixed bug with the Open method executes twice statements that do not return rows
Fixed bug with not closing portal for prepared statements
Fixed bug with detecting TablesInfo
Added support for TQuery.DataSource property in BDE Migration Wizard

1.10.0.5 02-Apr-09

Added support for Free Pascal under Linux
Added DMLRefresh support
Added NoPreconnect property to TPgScript for executing CONNECT and CREATE DATABASE commands
Fixed bug with DetailDelay and refreshing closed dataset
Fixed bug with detecting DBMonitor on 64-bit Windows
Fixed bug with not calling UnregisterClient for internal command of dataset
Fixed bug with refreshing record when RefreshOptions.roBeforeEdit is set and LockMode = lmImmediate
Fixed bug with the UnpreparedExecute option not affecting update SQLs
Fixed bug with processing PG_MSG_EMPTY_QUERY_RESPONSE

1.00.0.4 26-Feb-09

Added the UpnpreparedExecute option to TCustomPgDataSet that allows simple execution of statements
Added ability to backup user defined query to file or stream in TPgDump
Added the ObjectNames property to TPgDump
Added support for the Schemas metadata kind in the TPgMetaData component
Fixed bug with not working CachedUpdates in TVirtualTable
Fixed bug with suppressing errors in TVirtualTable.LoadFromFile
Fixed problem with restoring current row after refresh
Fixed bug when statements, executed on TClientDataSet.ApplyUpdates, were not shown in DBMonitor
Fixed access violation on the TClientDataSet.ApplyUpdates call
Avoided bug in Delphi 2006 and above with the BcdCompare function
Fixed bug with not executing prepared statement for the second time
Fixed bug with saving the TPgLargeObjectField.BlobType property in DFM
Fixed bug with TPgAlerter started at design-time when Active=False
Fixed memory leak in the UniDirectional mode (+Unidac)
Fixed bug with detecting read-only fields when ExtendedFieldsInfo=False
Fixed bug with reading large objects with size more than 64 Kb
Fixed problem with using TCRSSHChannel as IOHandler

1.00.0.3 06-Jan-09

First release of PgDAC