|
Major revision. Many internal changes have been made to support
Stored Procedures and other features. The driver was rewritten in
about 60%.
ADDED - UPDATES. Now
pgExpress executes delete/insert/update queries automagically :)
ADDED - PostgreSQL 7.2 support.
Not much had to be done, but it's there... take care about the OIDs
use in PostgreSQL 7.2 (OIDs are optional inPostgreSQL 7.2).
ADDED - Stored Procedures
support. Since PostgreSQL currently has no real support
for stored procudures, they are emulated through Functions (created
by using "create
function" SQL statments). Functions that return "opaque"
can't be supported because they can only be called by triggers or
rules. Functions that return "SETOF" types (datasets)
might be supported on a future version.
ADDED
- Translations. The driver can be translated to your own
language. Added also Portuguese translation of the driver. If you
want to contribute making a translation, please email
us. There are not too many strings to be translated :-).
ADDED
- Now the driver will read
extra, non-standard options from the dbxdrivers.ini file. Those
options include "TypesCachingMode", "TextAsBlob",
"MapUnkownAsString" and ArrayAsString.
ADDED
- A new version of the libpq library was added,
and the new PQescapeString and PQescapeBytea and PQfreeNotify functions
are now available.
ADDED - Added TypeMappings caching. The
PostgreSQL native types information will be cached on the driver
level (default), the connection level or the cursor level. PostgreSQL
requires a types lookup due to it's dynamic typing nature. This
option reduces traffic to the server and makes the driver faster.
As said, this option defaults to "driver" (meaning that
types will be cached only once per session) and can be changed by
setting the dbxdrivers.ini "TypesCachingMode" option.
For more details about TypeMappings caching, please refer to the
driver documentation.
For more information about the PostgreSQL types mechanism, please
refer to the PostgreSQL
Manuals.
ADDED
- "TextAsBlob" option. This dbxdrivers.ini setting
will make the text fields to be mapped as BLOBs. That can make you
support PostgreSQL 'text' fields larger then 32Kb.
ADDED
- "ArrayAsString" option. This dbxdrivers.ini setting
will make the arrays to be interpreted as pure strings (as read
from the server) instead of being parsed into array elements. Note
that arrays are only supported in the licensed driver.
ADDED
- "MapUnknownAsString" option. This dbxdrivers.ini setting
will make unknown types to be mapped as strings. Virtually all PostgreSQL
types can be supported using this option. This option defaults to
true on the driver but can be set to False if you don't like it.
ADDED
- The registered version of the driver now supports int2vector and
oidvector types, and maps them as integer arrays.
ADDED
- Database server checking. Now the driver will enforce that
PostgreSQL 7.1 or superior is being used. The driver is not compatible
with older servers.
ADDED - Callback function support.
Now the pgExpress driver will work properly with TSQLMonitors.
ADDED - Support for HostName parameter in dbxconnections.ini
file.
ADDED - If you close
a connection that is inside a transaction, the transaction will
be rolled back automatically.
CHANGED - Now the
driver will use the interface library specified by the "VendorLib"
parameter in the dbxdrivers file. If this is not set, defaults to
"libpq.dll" on windows systems, or "libpq.so"
on linux.
CHANGED - MANY internal
changes and optimizations. The driver should be more flexible then
ever.
CHANGED - Made driver
more compatible with other Borland drivers.
CHANGED - Improved the
way the driver handles the libpq library. This also makes possible
to load different libpq.dll libraries (if you ever want to).
FIXED - Fixed a bug where the
path environment would not be properly detected, causing the library
to not be located.
FIXED - Fixed a few blob bugs.
FIXED - Fixed a small fldVARBYTES
and fldBYTES bug (please document things better, Borland ;-) ).
|
|
Maintence release.
ADDED - Kylix support. pgExpress
is now also avaiable under Linux.
CHANGED - Updated the libpq.dll
interface library to one from a PostgreSQL 7.2 CVS snapshot. This
version fixes a bug where a query with more then 8191 bytes would
kill the database connection. This was actually a PostgreSQL bug,
not pgExpress.
FIXED - Fixed a bug where a
query with more then 8191 bytes would kill the database connection
(read above).
FIXED - Fixed a bug where the
path environment would not be properly detected, causing the library
to not be located. This error occurs only on a very few systems
and was very difficult to detect.
FIXED - Fixed "LIBPQ library
[%s] was not found". - argument '%s' was not being expanded.
|