PostgreSQL Data Access Components History

8.3.1 24-Oct-24

Restored support for RAD Studio 12 Athens Release 1
Added support for Lazarus 3.6

8.3.0 27-Sep-24

Added support for RAD Studio 12 Athens Release 2
Added support for C++Builder 64-bit Windows (Modern) Application Development
Added support for Lazarus 3.4
Improved performance
Added C++Builder demo components for working with SecureBridge
Added the WriteBOM property for TPgDumpOptions
Added support for the pgvector extension
Added the UseGeneratedColumns property for TPgDataSetOptions
Fixed bug with getting default field values when using a not default public schema
Fixed bug with parsing a composite data type
Fixed bug with the query when MATERIALIZED is used
Fixed bug with Access Violation when converting an empty timestamp value
Fixed bug with a user using tables named pg_class
Fixed bug with using tables with the same names in different schemas
Fixed bug with the query "SHOW ALL" when the FetchAll option is set to False
Fixed the transaction bug when using RefreshRecord
Fixed bug with parsing numeric data type when using arrays in a query
Fixed bug with parsing interval data type

8.2.1 01-May-24

Now Release 1 for RAD Studio 12 Athens, Delphi 12 Athens, and C++Builder 12 Athens is required
Fixed internal bug with TSharedObject

8.2.0 24-Apr-24

Added support for RAD Studio 12 Athens Release 1
Added support for Lazarus 3.2
Improved work with generated fields
Fixed bug when processing identity field

8.1.0 19-Feb-24

Added support for Lazarus 3.0
Improved work with column default values
Improved work with RefreshRecord queries
Improved work with arrays in queries
Fixed bug with "Current transaction is aborted, commands ignored until end of transaction block."
Fixed bug with "Multiple transactions are not supported by the database."
Fixed bug with "date/time field value out of range" for IDE12 Win64 target platform

8.0.0 15-Nov-23

Added support for RAD Studio 12
Added support for PostgreSQL 16
Added support for macOS Sonoma
Added support for iOS 17
Added support for Android 13
Added support PREPARE/EXECUTE commands
Added support for nested Macros in SQL queries
Added support Display Format for Aggregate fields
Added SHA-2(SHA-256, SHA-512) in hash algorithm for encryption
Fixed bug with "SSL function is not linked. You should update the SSL client library."
Fixed bug working with schemes in the connection pool
Fixed bug with adding a condition to the WHERE clause on calling RefreshRecord
Fixed bug with SCARM-SHA-256 certificates
Fixed bug with calling RefreshRecord when UnpreparedExecute is set to True
Fixed bug with moving the cursor when using Aggregate fields
Fixed bug with deleting a record when using Aggregated fields
Fixed bug with storing empty Aggregates collection in DFM
Fixed bug with AV when installing a package in the IDE
Fixed bug with AV in the CloneCursor method of the dataset
Fixed bug with using Aggregated and InternalCalc fields together
Fixed bug with duplicate resource IDs in CBuilder
Fixed bug with using "NOT Field LIKE" construction in Filter property

7.4.0 17-Mar-23

Added support for RAD Studio 11 Alexandria Release 3
Added support for iOS Simulator ARM 64-bit target platform
Added support for Lazarus 2.2.6
Added support for PostgreSQL 15
Added support for the YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, GETDATE, DATE, TIME, TRIM, TRIMLEFT, TRIMRIGHT statements in TDADataSet.Filter
Added support for the mathematical operations in TDADataSet.Filter
Added support for Aggregate Fields and InternalCalc Fields
Added ability to restore from file with TEncoding via the Dump component
Improved process of getting extended fields info
Now the SetRange will function according to the case sensitivity of keywords in IndexFieldNames
Fixed bug with array types in the Dump component
Fixed bug with extra connections in GetType methods
Fixed bug with reading fields of type REAL using the Auto protocol
Fixed bug with writing Bytea type in Batch operations
Fixed bug with using "ON CONFLICT RETURNING" in batch operations
Fixed bug with the "Range Check Error" exception when reading BLOB data
Fixed problem with handling fields of type REAL
Fixed bug with TIMESTAMPTZ fields

7.3.0 12-Sep-22

Added support for RAD Studio 11 Alexandria Release 2
Added support for Lazarus 2.2.2
Added support for iOS 15
Added support for Android 12
Added support for PostGIS
Added the CloneCursor method for Query and Table components that allows sharing data between datasets
Improved TimeZoneOffset support for TPgTimeStamp
Improved the Truncate method of the TPgLargeObject class
Improved the performance of exporting to XML
Fixed bug with executing a SELECT statement via the Execute method of the Query component
Fixed bug with the Ping method of the Connection component when the MultipleConnections property is set to False
Fixed bug with the "Record was changed by another user" exception when editing a dataset that contains double precision fields
Fixed bug with "Invalid TimeStamp string" when the date has YYYY-MM-DD format
Fixed bug when a connection string parameter value contains a single quote
Fixed bug with international characters in error messages

7.2.1 12-Apr-22

RAD Studio 11 Alexandria Release 1 is supported
Lazarus 2.2.0 is supported
Windows 11 is supported
macOS Monterey is supported
The SCRAM-SHA-256-PLUS authentication mechanism is supported
"ON CONFLICT" in batch operations is supported
Open connection performance is improved
The AddDelete property for the Dump component is added
Dumping of stores procedures via the Dump component is added
Fixed bug with saving JSON fields
Fixed bug with the reading of type real
Fixed bug with TFieldDesc.IsAutoIncrement = False for fields created as "GENERATED ALWAYS AS IDENTITY"
Fixed bug with resetting param values when changing param values count
Fixed bug with HTTPS tunneling in the Direct mode
Fixed bug with AV when using the TCRSSLIOHandler from the SecureBridge demo project as an IOHandler for a connection

7.1.1 09-Dec-21

PostgreSQL 14 is supported
OUT parameters in stored procedures for PostgreSQL 14 are added
The PoolId connection pool option is added
Fixed bug with Access Violation on RefreshRecord after connection switching
Fixed bug with application name when connection pooling is used
Fixed bug with using "ON CONFLICT DO NOTHING" in batch operations
Fixed bug with processing large OID values
Fixed bug with freezing multiply connection pools in threads
Fixed bug with using the AsDate property when working with fields of the ftDate type
Fixed bug with updating the state of records at applying cached updates

7.0.1 13-Sep-21

RAD Studio 11 Alexandria is supported
macOS ARM is supported
Added demo project for FastReport FMX
Fixed bug with processing UUID fields
Fixed bug with processing large OID values
Fixed bug with the incorrect encoding of error messages
Fixed bug with the incorrect RowsAffected result of the WITH ... statement
Fixed bug with error when setting the "0" value for a currency field
Fixed bug with automatic conversion of null values from SQL subqueries to default values
Fixed bug with processing IDENTITY fields in the PgDump component
Fixed bug with CanModify = False in the Table component when opening a temporary table
Fixed bug with using the Dump component with PostgreSQL version 8.1 and earlier
Fixed bug with executing stored procedures in PostgreSQL version 8.1 and earlier
Fixed bug with using batch inserts in PostgreSQL version 8.2 and earlier
Fixed bug with setting a DateTime value before the year 1800 to TTimeField
Fixed bug with using a BLOB field in the IndexFieldNames property of the DataSet component
Fixed bug with memoty leak on Locate by field with data type mapping
Fixed bug with escaping wildcards in the Filter property of the DataSet component

6.4.4 14-Jul-21

Support for TFieldOptions is added
Bug with executing a stored procedure when ProtocolVersion = pvAuto is fixed
Bug with executing a "SELECT FROM ..." statement is fixed
Bug with a "Range check error" exception when executing a statement with parameters is fixed
Bug with AV when executing a "SET ROLE ..." statement is fixed
Bug with updating a table that has a Serial field is fixed
Bug with handling statement parameters of the ftUnknown data type is fixed
Bug with applying both Encryption and Data Type Mapping on a BLOB column is fixed
Bug with AV after adding the Lookup field to a prepared DataSet is fixed

6.4.3 06-Apr-21

Demo compatibility with new a version of SecureBridge is fixed
Bug with reading date value "2000-01-01" when the EnablePgTimestamps option is set to True is fixed
Bug with reading server messages is fixed

6.4.2 26-Mar-21

Several bugs with the MultipleConnection option are fixed
Several bugs with ProtocolVersion = pvAuto are fixed
Bug with AV when opening a form containing a SQL component is fixed
Bug with LockMode = lmPessimistic is fixed
Bug with the ConvertEOL connection option is fixed
Bug with AV in applications using DBMonitor is fixed
Bug with committing a transaction when LockMode = lmPessimistic is fixed
Bug with getting values of calculated fields is fixed

6.4.1 02-Mar-21

PostgreSQL 13 is supported
RAD Studio 10.4.2 Sydney is supported
macOS 11 Big Sur is supported
iOS 14 is supported
Android 11 is supported
Work in a multi-threaded environment through a single connection is supported
The MultipleConnections option in the Connection component is added
Performance of batch operations is improved
Performance of the FindFirst, FindNext, FindLast, and FindPrior methods is improved
Bug with setting the ReadOnly field property at runtime is fixed
Bug with AV failure when using OpenSSL 1.1 libraries is fixed
Bug with an incorrect value of the RowsAffected property when executing an INSERT ... RETURNING statement is fixed
Bug with the "Unexpected server response" error when executing a "SELECT FROM ..." statement is fixed
Bug with AV when executing a batch operation via the SQL component is fixed
Bug with incorrect encoding of error messages is fixed
Bug with reading BLOBs on mobile platforms using Protocol 2 is fixed

6.3.2 14-Sep-20

Now Release 1 for RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, and C++Builder 10.4 Sydney is required
Incompatibility of DatasetManager with RAD Studio 10.4 Release 1 is fixed

6.3.1 26-Aug-20

Lazarus 2.0.10 and FPC 3.2.0 are supported
Performance of Batch Insert, Update, and Delete operations is improved

6.2.4 01-Jun-20

RAD Studio 10.4 Sydney is supported
Lazarus 2.0.8 is supported
macOS 64-bit in Lazarus is supported
The Line geometric type is supported
Bug with the Dump component in PostgreSQL 12 is fixed
Bug with reading zero-valued geometric fields as nulls is fixed
Bug with locating a record by a fixed string column in the Chinese locale is fixed
Bug with LocalMasterDetail when DataTypeMapping is enabled is fixed

6.1.3 10-Mar-20

Bug with installing different editions of two or more DAC's in a single system is fixed
Bug with executing a query which has a param of type date is fixed
Bug with AV on closing an application that uses the Alerter component is fixed
Bug with an incorrect value of the RowsAffected property when executing an INSERT ... RETURNING statement is fixed
Bug with SQL statements that contain fields with the same name from different tables is fixed
Bug with executing SQL statements that contain comments using the Script component is fixed
Bug with resetting the value of the parameter after adding a new TDACondition is fixed
Bug with reading a field value using the AsBytes method in Lazarus is fixed
Bug with using constraints after calling the Refresh method is fixed

6.1.2 26-Nov-19

Android 64-bit is supported
Lazarus 2.0.6 is supported
PostgreSQL 12 is supported
OpenSSL 1.1 library is supported
Now Trial edition for macOS and Linux is fully functional
Bug with AV failure when using encryption is fixed
Bug with using the FieldOrigins property is fixed
Bug with the Loader component when UniDirectional set to True for source dataset is fixed
Bug with "Record changed by another user" error when LockMode <> lmNone is fixed
Bug with mapping to BCD fields when TClientDataSet is used is fixed
Bug with resetting the range values when executing the Refresh method is fixed
Several bugs that occurred when using DataSet Manager are fixed

6.0.1 22-Jul-19

macOS 64-bit is supported
Release 2 for RAD Studio 10.3 Rio, Delphi 10.3 Rio, and C++Builder 10.3 Rio is now required
TPgConnectionSSLOptions.IgnoreServerCertificateInsecurity property is added
Bug with using the AsMemo method in batch operations is fixed

5.4.10 24-Jun-19

Lazarus 2.0.2 is supported
The pmAuto value for the ProtocolVersion property is added
Now ProtocolVersion is set to pmAuto by default, which significantly improved performance
Possibility to use function calls in batch operations is added
The mVerifyCA and smVerifyFull options for the SSLOptions.Mode property of the TPgConnection component are added
The DefaultSortType property for TVirtualTable is added
Performance of the SaveToFile/LoadFromFile methods of TVirtualTable is significantly increased
Bug in TPgDump with backing up sequences in PostgreSQL 10 or later is fixed
Bug with the AV failure when executing the Refresh method is fixed
Bug with calculating percentage in the OnRestoreProgress event in the TDADump class is fixed
Bug with the StackOverflow exception when using batch operations in CBuilder is fixed
Bug with using the SetRange method is fixed

5.3.9 21-Jan-19

Bug with reading and writing of the floating point values is fixed
Bug with AV failure in the Refresh method in RAD Studio 10.2 Tokyo on Linux is fixed

5.3.8 26-Nov-18

RAD Studio 10.3 Rio is supported
PostgreSQL 11 is supported
Support of UPPER and LOWER functions for Unified SQL is added
Bug with SIGPIPE signal on Linux while connection reset is fixed
Bug with using the FieldOrigins property is fixed
Bug with using the TrimFixedChar property is fixed
Bug with saving a dataset that contains BLOB fields to XML is fixed

5.2.7 17-Sep-18

Automatic detection of the initial value of an AutoInc field in TVirtualTable is supported
Now the SetRange method supports Null values
The enumerated property FieldOrigins is added
The Boolean property FieldsOrigin is deprecated
Bug with AV when using custom constraints is fixed
Bug with reading large double values from NUMERIC fields is fixed

5.2.6 09-Jul-18

Lazarus 1.8.4 is supported
Performance of batch operations is improved
Support for HTTP/HTTPS tunnel is added
Demo projects for IntraWeb 14 are added
Memory leak in NEXTGEN is fixed
Bug with retrieving the result recordset when using an INSERT ... RETURNING statement in batch operations is fixed
Bug with slow performance when inserting data into a table having domain fields is fixed
Bug with a connection error using SSL on some servers is fixed
Bug with updating a record when using the OnFilterRecord event handler is fixed
Bug with using encryption and CacheCalcFields option is fixed
Bug with using a backslash in the Filter property is fixed
Bug with using First method in the Master-Detail relationship is fixed

5.1.5 02-Apr-18

Lazarus 1.8.2 is supported
Now Detail dataset is not refreshed when Master dataset editing is started.
Bug with executing batch operations with iteration = 1 and offset = 0 is fixed
Bug with re-opening a filtered dataset is fixed
Bug with data decryption in SmartFetch mode is fixed
Bug with data truncation while decrypting is fixed
Bug with assertion failure when using the local filter with GUID field is fixed
Bug with executing batch operations when a SQL statement contains function calls as values is fixed
Bug with loading data into uuid fields using the Loader component and Protocol 3 is fixed

5.1.4 18-Jan-18

PostgreSQL 10.1 is supported
Lazarus 1.8 and FPC 3.0.4 are supported
Support for custom constraints is added
The UseBlankValues property for the Loader component is added
Bug with mapping jsonb fields is fixed
Bug with the FieldDefs.Update method of a dataset when using the protocol version 3.0 is fixed
Bug with reading GUID data on mobile platforms is fixed
Bug with the Locate method work for the TGuidField class is fixed
Bug with calling RefreshRecord when setting FullRefresh to True and using encryption is fixed
Bug with assertion failure when adding Calculated fields after calling Prepare is fixed
Bug with using the AsDateTime property when working with fields of the ftDate or ftTime type is fixed
Bug with assertion failure when using the OnFilterRecord event handler is fixed
Bug with script parsing in TDAScript is fixed
Bug with AutoInc fields in TVirtualTable is fixed
Bug with AV in TVirtualDataSet when editing Blob is fixed

5.1.3 19-Sep-17

SSPI authentication is supported
Processing GUID data type for the TGuidField class is improved
Bug with generating SQL for batch updates is fixed
Bug with the Locate method for non-Windows platforms in Lazarus is fixed
Bug with the FindFirst, FindLast, FindNext, FindPrior methods in Lazarus is fixed
Bug with accessing a product help from the IDE menu is fixed
Bug with recreating fields when calling Open after Prepare is fixed
Bug with an incorrect error message when using the Connect dialog component on mobile platforms is fixed
Bug with AV failure when using calculated fields in TClientDataset is fixed
Bug with a key violation error when executing batch operations is fixed
Bug with Assert when calling the Locate method in the SmartFetch mode is fixed
Bug with using DAC components in DataModule for Linux is fixed

5.0.2 15-May-17

Bug with AV failure after executing the Ping method is fixed
Bug with processing NULL values in the Loader component is fixed
Bug with executing a query after executing a batch command is fixed
Bug with using the AsGuid property is fixed

5.0.1 05-Apr-17

RAD Studio 10.2 Tokyo is supported
Linux in RAD Studio 10.2 Tokyo is supported
Lazarus 1.6.4 and Free Pascal 3.0.2 is supported
Bug with the RefreshRecord method is fixed
Bug with escaping international characters when using protocol version 2 is fixed
Bug with executing a stored procedure via the Query component with FetchAll = False is fixed
Bug with executing a batch operation after changing SQL is fixed
Bug with international characters in error messages is fixed
Bug when working with the TBytes and TVarBytes fields in TVirtualTable is fixed
Bug with detecting parameters by name in ExecSQLEx is fixed
Bug with reading Memo as WideMemo is fixed
Bug with field name quoting in a filter expression is fixed
Bug with handling parameter values of BLOB type in batch operations is fixed
Bug with memory leak in TVirtualDataSet is fixed

4.7.27 21-Nov-16

Bug with adding Calculated fields after calling Prepare is fixed
Bug with stored procedure parameters is fixed

4.7.26 01-Nov-16

Bug with raising 'Argument out of range' error on TCRDBGrid creating in RAD Studio Berlin with Update 1 is fixed
Bug with QueryRecCount when ORDER clause contains CASE..END is fixed
SSL support is fixed

4.7.25 08-Sep-16

TDADataSetOptions.InsertAllSetFields property is added
Several bugs in SmartFetch Mode are fixed
Bug with setting the TCustomDADataSet.EOF property after fetch canceled is fixed
Bug with param values loss after changing TDAParam.ValueCount is fixed
Bug with PtrOffset function when Overflow Checking option enabled is fixed
Bug with the "DisposeBuf failed" error when canceling dataset changes is fixed
Bug with the duplicated MacroChar variable is fixed
Bug with international characters in error messages is fixed
Bug with querying nested tables is fixed
Bug in PgDump when using VARIADIC function arguments is fixed
Bug with canceling a fetch is fixed

4.7.24 27-Jun-16

TVirtualDataSet component is added
Bug with assertion failure on editing data in SmartFetch mode is fixed
Bug with AV on application closing when DLLs are used in the Trial edition is fixed
Bug with using parameters and column aliases in Master-Detail relation is fixed
Bug with AV on connection lost is fixed
Bug with the incorrect milliseconds part of timestamp fields is fixed

4.7.23 28-Apr-16

Bug with AV failure when connection is not specified is fixed
Bug with batch operations is fixed
Bug with AV failure in the TPgConnection component when Options.UseUnicode = True is fixed

4.7.22 25-Apr-16

RAD Studio 10.1 Berlin is supported
Lazarus 1.6 and FPC 3.0.0 is supported
PostgreSQL 9.5 is supported
Support for the BETWEEN statement in TDADataSet.Filter is added
A MessageCharset option in connection options is added
Bug with handling international characters in the VirtualTable component is fixed
Bug with displaying data in grid on error at applying cached updates is fixed
Bug in the SetOrderBy method in case when SQL contains ';' is fixed
Bug with using the LIKE clause in a dataset filter is fixed
Bug in TVirtualTable.Assign method on NULL values in Required fields is fixed
Bug with HTML entities replacing on XML data loading to TVirtualTable is fixed
Bug with setting the SkipUnsupportedFieldTypes option of TVirtualTable is fixed
Bug with retrieving TimeStamp from string is fixed
Bug with Dump component when using protocol version 2 is fixed
Bug with storing timestamp field values is fixed
Generating of UpdateSQL on using WITH construct is fixed

4.6.21 01-Feb-16

Data Type Mapping performance is improved
RepeatableRead and ReadUncommitted transaction isolation levels are added

4.6.20 14-Dec-15

Performance of TDALoader on loading data from TDataSet is improved
Several bugs in the SmartFetch mode are fixed
Bug with processing the cached data in the ApplyUpdates method is fixed
Bug with RecNo in the Unidirectional mode is fixed
Bug with storing some numbers with floating point is fixed
Bug with dumping character data with the Dump component is fixed
Bug with encoding server error responses is fixed

4.6.19 18-Sep-15

Critical bug with parsing query parameters is fixed
Bug with showing values array for batch updates in SQLMonitor is fixed
Bug with editing Blob and Memo fields used in local filter is fixed

4.6.18 09-Sep-15

RAD Studio 10 Seattle is supported
INSERT, UPDATE and DELETE batch operations are supported
Support of bit and bit varying data types is improved
Now Trial for Win64 is a fully functional Professional Edition
Now at automatic refresh of Detail dataset the OnBeforeOpen event is not called
Generating conditions for filtration when using similar field names and aliases in TCRDBGrid is fixed
SQLMonitor behavior on using similar objects is fixed
Bug with endless reconnection in assigned connection is fixed
Bug with editing Blob and Memo fields used in local filter is fixed
Bug with inserting to JSON fields is fixed

4.5.17 14-Jul-15

Critical bug with data encryption is fixed
Bug in IProviderSupport.PSExecuteStatement with parsing a SQL query is fixed
Bug with missing IdeVer.inc in Trial version is fixed
Bug with storing BYTEA fields when UnpreparedExecute=True is fixed
Bug in TPgLoader.LoadFromDataSet is fixed

4.5.16 30-Jun-15

Bug when parsing SQL query with parameters is fixed
Bug with the Refresh method in the SmartFetch mode is fixed

4.5.15 17-Jun-15

Several bugs when using PostgreSQL 8.0 are fixed
Bug with using bookmarks in a filtered dataset is fixed
Bug with restoring the original order of records after clearing IndexFieldNames is fixed
Bug with refreshing DbLookupComboBox of the detail dataset when Master-Detail relationship is used is fixed
Bug with SQL Monitor freezing when using in a DLL is fixed

4.5.14 14-Apr-15

RAD Studio XE8 is supported
AppMethod is supported
PostgreSQL 9.4 is supported
The AutoRestart property for the Alerter component is added
Bug with invalid names of Master-Detail parameters is fixed
Bug with AV on calling GetVersion() in C++Builder is fixed
Bug with backup of time and timestamp columns using the Dump component is fixed
Bug with handling function parameters of object type is fixed

4.4.13 14-Jan-15

Lazarus 1.2.6 is supported
Bug with the "Input\Output error(5)" error on Connect for non-Windows platforms is fixed
Bug with losing data after VirtualTable closing on SaveToStream is fixed
Bug with RestoreUpdates in CachedUpdates mode is fixed

4.4.12 25-Nov-14

The ImmediateNotices connection option is added
Bug when using table aliases in the DetailFields name is fixed
Bug with using UPPER and LOWER functions in filter is fixed
Bug with the "Input\Output error(5)" error on Connect for non-Windows platforms is fixed
Bug with setting TParam.Value = for a parameter with the ftDate data type is fixed
Bug with TCustomDADataSet.FindKey is fixed
Bug with editing DateTime fields when data type mapping from string to DateTime is used is fixed
Bug with 'Thread Error' when connecting on OS X is fixed
Bug with refreshing record if the key field has the TSQLTimeStamp data type is fixed
Bug with escape quoting in PgDump is fixed
Bug with retrieving current schema name on enabled DataTypeMapping is fixed
Bug with Refresh method when DisconnectedMode = True and Pooling = True is fixed

4.4.11 29-Sep-14

ConnectionTimeout is now used on OSX and Mobile platforms
Bug with RecNo in the UniDirectional mode is fixed
Bug with setting SQL query when ParamCheck = False is fixed
Bug with AV failure on getting metadata by TCustomDADataSet is fixed
Bug with AV failure under Mobile when DacFMX is used is fixed
Backup of huge BLOB-fields with TPgDump is fixed

4.4.10 15-Sep-14

RAD Studio XE7 is supported
Lazarus 1.2.4 is supported
Demo projects for FastReport 5 are added
The TCustomDADataSet.GetKeyFieldNames method is added
The TCustomDAConnection.GetKeyFieldNames method is added
The ConstraintColumns metadata kind for the TDAMetadata component is added
Several bugs in the SmartFetch mode are fixed
Bug with quoting names in the EmptyTable method is fixed
Bug with calling the Refresh method after executing the EmptyTable method is fixed
Bug with setting calculated field values using the AsExtened property is fixed
Bug with re-calling the AfterExecute event is fixed
Bug with re-calling the BeforeExecute event is fixed

4.3.9 31-Jul-14

Support for the Upper and Lower statements in TDADataSet.Filter is added
Support for the ftOraTimeStamp type in TVirtualTable is added
The SQL property is added to TPgConnection
The TPgTable.EmptyTable method is added
A dump file format for the Dump component when UseUnicode=True is improved
Bug with reopening TDADataSet after BreakExec is fixed
Several bugs in the SmartFetch mode are fixed
Bug with processing calculated and lookup fields in the SmartFetch mode is fixed
Bug with getting RecordCount when QueryRecordCount is True is fixed
Bug with AV failure on opening TCustomDADataSet when Range was set is fixed
Bug with "Invalid field size" in TVirtualTable is fixed
Bug with AV failure on freeing objects on mobile platforms is fixed
Bug with incorrect parsing of table names containing a "$" character is fixed
Bug with cutting comments in SQL query is fixed
Bug with assigning the IOHandler property when TPgConnection.Assign is performed is fixed

4.3.8 27-May-14

Bug with compilation in C++Builder is fixed
Bug with setting boolean parameters in a non-English IDE at design-time is fixed
Bug with AV failure on fetching records in the UniDirectional mode is fixed
Bug with finding master parameters by original name on refreshing record when using master/detail relationship by parameters is fixed

4.3.7 29-Apr-14

RAD Studio XE6 is supported
Android in C++Builder XE6 is supported
Lazarus 1.2.2 and FPC 2.6.4 is supported
SmartFetch mode for TDataSet descendants is added
Now update queries inside TDataSet descendants have correct owner
The TPgDataSetOptions.MasterFieldsNullable property is added
The SetOrderBy method behavior is fixed
The GetOrderBy method behavior is fixed
Bug with displaying already installed DAC version in setup messages is fixed
Bug with the Filter behavior in the Metadata component is fixed
Bug with AV on modify table with one only Object field is fixed
Bug with Locate when a NULL value is present in the index field is fixed
Bug with IndexFieldNames when DataTypeMapping is enabled is fixed
Bug in TPgQuery with bpchar fields when FlatBuffers=False and UnknownAsSring=True is fixed
Bug with parsing dollar-quoted strings is fixed
Bug when opening PgConnection editor in Lazarus is fixed
Bug with "Range check error" in Protocol 2 is fixed
Bug with executing "WITH ... SELECT" statements is fixed
Bug with freeing memory in the TDADataSet.Lookup method is fixed
Bug with SSL connection on Android is fixed
Bug with error processing on socket data reading under Unix is fixed

4.2.6 19-Feb-14

Possibility to use MAS_ prefix for parameters when using master/detail relationship is added
The TPgCustomDataSet.Options.DistinctParams property is added for correct TClientDataSet parameters handling
Bug with post data when LockMode=lmOptimistic and Data Type Mapping is applied is fixed
Bug with opening dataset when persistent fields were created in dataset is fixed
Bug with parameter name quoting on assigning field value to parameter is fixed
Bug with deleting a record inserted earlier in CachedUpdates mode is fixed
Bug on sorting BLOB fields is fixed
Bug with percentage count in the OnRestoreProgress event of the TDADump class is fixed
Bug with generating SQL queries by "SQL Generator" in design-time is fixed
Bug with using '$' and '#' symbols in a parameter name is fixed
Bug in TPgDump on types backup in old PostgreSQL versions is fixed
Bug when working with parameters of domain types is fixed
Bug in TPgQuery when FlatBuffers=False and UnknownAsSring=True is fixed

4.2.5 25-Dec-13

iOS in C++Builder XE5 is supported
RAD Studio XE5 Update 2 is now required
Now .obj and .o files are supplied for C++Builder
A list of available Charsets in TPgConnection at design-time is added
Default charset detecting for Windows is added
Compatibility of migrating floating-point fields from other components is improved
Bug with data loss when updating records in the CachedUpdates mode is fixed
Bug with connecting under Windows 2000 and lower is fixed
Bug with RefreshRecord in the CachedUpdates mode is fixed
Bug with mapping to BCD and FmtBCD types is fixed
Bug with mapping single types to float types is fixed
Bug with data display in Detail Dataset when master field is Null is fixed
Bug with mapping to BCD fields when using TClientDataSet is fixed
Bug with incorrect parameter sizes when re-opening a query is fixed
Bug with filtering boolean fields is fixed
Bug with freeing complex fields after refreshing before editing is fixed
Bug with Locate by fields where Data Type Mapping is applied is fixed
Bug with RefreshQuick when IndexFieldNames is set is fixed
Bug when working with fields of composite types is fixed
Bug with executing parametrized queries when using protocol version 2 is fixed
Bug with handling international characters when using protocol version 2 is fixed
Bug with backup of ENUM types using the Dump component is fixed

4.1.4 23-Sep-13

Critical bug with parsing unicode SQL queries is fixed

4.1.3 18-Sep-13

RAD Studio XE5 is supported
Application development for Android is supported
Lazarus 1.0.12 is supported
Performance is improved
Automatic checking for new versions is added
Flexible management of conditions in the WHERE clause is added
PostgreSQL 9.3 is supported
IPv6 protocol support is added
Support of the IN keyword in the TDataSet.Filter property is added
Like operator behaviour when used in the Filter property is now similar to TClientDataSet
The possibility to use ranges is added
The Ping method for the Connection component is added
The AllowImplicitConnect option for the Connection component is added
The SQLRecCount property for the Query and StoredProc components is added
The ScanParams property for the Script component is added
The RowsAffected property for the Script component is added
The EnableDomains option is added for TPgConnection
ConnectionTimeout is now used when disconnecting after connection loss
The TPgTable.TableName and TPgStoredProc.StoredProcName property editors are improved
Bug in TDALoader with data loading from Dataset when the FetchAll option is set to False is fixed
Bug with TDALoader.LoadFromDataSet is fixed
Bug with storing the dbMonitor active state to DFM is fixed
Bug with setting ConnectionTimeout for Unix, Mac OS and iOS platforms is fixed
Bug with incorrect displaying of long names of parameters and macros in design-time is fixed
Bug with processing cached data when UpdateRecordTypes is not default is fixed
Bug with moving data from WideMemo to String fields by TCRBatchMove is fixed
Bug in TCRBatchMove when destination dataset has no key fields is fixed
Bug with TCRBatchMove and DataSets in the UniDirectional mode is fixed
Bug with showing a connection dialog in design-time when LoginPrompt is set to False is fixed
Bug with setting the connection string containing inline comments is fixed
Bug with unnecessary unlock calling after an update error is fixed
Bug with AssignConnect from a disconnected source connection is fixed
Bug when UnpreparedExecute option is set to True is fixed
Bug with an "Invalid password packet size" message in the PostgreSQL log is fixed
Bug with a zero-valued LastInsertOID result is fixed

4.0.2 15-Jul-13

Connection dialog is improved
Incorrect XE4 behaviour when re-opening a dataset under iOS is fixed
Bug with geometric, interval and datetime types is fixed
Bug with multiple metadata requests when using domain field types is fixed
Bug in the alerter when DisconnectedMode is set to True for a connection is fixed
Bug with the connection OnLogin event is fixed
Bug with incorrect counting of connections in pool is fixed
Bug with time fields in Lazarus is fixed
Bug with varbinary fields in Lazarus is fixed
Bug with using case-insensitive filter is fixed
Bug with getting and setting the SQL property of FastReport datasets is fixed
Bug with positioning of Fields Editor is fixed
Bug with not using index fields on locating records is fixed
Bug with processing the cached data when UpdateRecordTypes is not default is fixed
Bug with processing persistent fields in TVirtualTable is fixed

4.0.1 25-Apr-13

Rad Studio XE4 is supported
NEXTGEN compiler is supported
Application development for iOS is supported
Connection string support is added
Possibility to encrypt entire tables and datasets is added
Possibility to determine if data in a field is encrypted is added
Support of TimeStamp, Single and Extended fields in VirtualTable is added
Support for custom mapping of numeric fields with BCD and FmtBCD types is added
Now TPgError.ErrorCode indicates a socket error code when a connection error appears
Bug with Master-Detail for TClientDataSet in Rad Studio XE3 is fixed
Bug with Master-Detail by non-English fields is fixed
Bug with IndexFieldNames by non-English fields is fixed
Bug with incorrect RecordCount result when a query contains both ORDER BY and LIMIT is fixed
Bug with calling Cancel in the BeforePost event is fixed
Bug when setting the TDataSet.Filter property for empty dataset is fixed
Bug with incorrect TVirtualTable version displaying in the About box is fixed
Thread handle leak when using pooling is fixed
SSL support in Mac OS is fixed
Bug with assigning ApplicationName in the AssignConnect method is fixed
Bug with mapping CHARACTER VARYING fields to ftString is fixed
Bug with automatic transaction restart when FetchAll = False on connection loss is fixed
Bug with TPgLoader.LoadFromDataSet when UniDirectional = True and FetchRows = 1 is fixed
Bug with TPgConnection.Connect when Pooling = True is fixed
Now the TCustomDASQLMonitor.Options.moDBMonitor property is set to False by default

3.6.12 14-Feb-13

Rad Studio XE3 Update 2 is now required
Bug with AV on adding TFieldDef items to FieldDefs for Delphi 2009 and higher is fixed
Bug with incorrect detection of the numeric parameter type in ExecSQL is fixed
Bug with assigning data to blob fields when using Data Type Mapping is fixed
Bug with inserting a new record into TStringGrid in FMX is fixed
Bug with unlocking a record after constraint violation is fixed
Bug with quoting index field names in TCRDBGrid is fixed
Bug with Master-Detail link by fields with non-English names is fixed

3.6.11 12-Dec-12

Rad Studio XE3 Update 1 is now required
C++Builder 64-bit for Windows is supported
Bug with using quoted field names in the IndexFieldNames property is fixed
Bug in TPgStoredProc with closing dataset when the Disconnected property is True is fixed
Bug with processing macros named in Cyrillic is fixed
Bug with resolving hostname on iOS device is fixed

3.5.10 07-Nov-12

Some improvements for NEXTGEN support are added
Support for ftGraphic and ftFmtMemo parameter data types is added
Informativity of messages about errors in connection is improved
Now the TPgAlerter component is also supported in Lazarus for Mac OS X
Dependency of design-time packages on FMX packages is removed
Bug with data loss in pessimistic lock mode is fixed
Bug with AV failure in RefreshQuick method is fixed
Bug with renaming of fields with the same names is fixed
Bug with dependency parameters count in macros on delimeter is fixed
Bug with storing the LoginPrompt connection property is fixed
Bug with dump data from VIEW is fixed
Bug with creating columns on setting the TableName property in TDALoader is fixed
Bug when processing domain type procedure parameters is fixed
Bug with processing composite type fields is fixed
Bug with executing a stored procedure when multiple default schema names are set in the connection is fixed
Bug in the TPgQuery.BreakExec method is fixed
Bug with assigning a value to the dataset parameter of an undefined type using the Param.Value is fixed

3.5.9 04-Sep-12

Rad Studio XE3 is supported
Windows 8 is supported
Bug with storing empty MapRules collection in DFM is fixed
Bug with empty TABLESPACE at table backup by TPgDump when QuoteNames=True is fixed

3.2.8 24-Jul-12

Bug with compilation for iOS is fixed
Bug with application hang at connection loss is fixed
Bug with infinite loop at PgAlerter stop after connection loss is fixed
Bug with Data Type Mapping and persistent fields is fixed
Bug with Data Type Mapping to Bytes and VarBytes is fixed
Bug with decryption of binary fields is fixed
Bug with editing calculated fields is fixed
Connection dialog is now open in the screen center instead of the desktop center
Several bugs with compilation on Delphi XE2 from Source code are fixed

3.2.7 21-Jun-12

Update 4 Hotfix 1 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
Data Type Mapping support is added
Data Encryption in a client application is added
The TPgEncryptor component for data encryption is added
Calling of the TCustomDASQL.BeforeExecute event is added
Bug with executing a script that ends with a commented line is fixed
Bug with assigning outsize data to TWideStringField is fixed
Bug with getting metadata for PostgreSQL 7.x is fixed
Bug with AV failure at calling the SetRecNo method when using local sorting is fixed
Bug in design time editor of the TVirtualTable component with master-detail relationship is fixed

3.1.6 02-Apr-12

Lazarus 0.9.30.4 and FPC 2.6.0 are supported
Bug with SQL Generator in the design-time is fixed
Bug with generating Update SQL with fields that have aliases is fixed
Bug with retrieving the list of tables from a case-sensitive schema is fixed
Bug with saving BCD fields from TVirtualTable to a Stream is fixed
Bug with LocalMasterDetail is fixed

3.1.5 01-Mar-12

Update 4 for RAD Studio XE2, Delphi XE2, and C++Builder XE2 is now required
The Time(x) and the TimeStamp(x) data types support is improved
Bug with showing error messages with German locale in Delphi 7 is fixed
Bug with backup/restore of case dependent sequences in PgDump is fixed
Bug with Out of memory in the server inside a Transaction is fixed
Bug with sending parameters as Float value is fixed
Big with schema names that contain "." is fixed
Bug with the absent CRControls10p.res file in the installation for Delphi 2006 is fixed
Bug with Data Editor in the design-time for case-sensetive Master-Detail link is fixed
Bug with hanging RAD Studio XE2 when opening ConnectDialog is fixed
Bug with AV failure at executing ApplyUpdates is fixed
Bug with Null values filtering in CRDBGrid is fixed
Bug at working with 64-bit pointers is fixed.
Several bugs in design-time editors are fixed

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 TPgSQLMonitor 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

Initial release of PgDAC