psqlODBC versions

Creates and manages PostgreSQL server connections
Nov 17, 2023
Jan 22, 2018
Review
9.3
Nov 2, 2014
Review
9.0
Oct 11, 2010
Review
8.3
Mar 1, 2008
8.2
Jul 25, 2008
Feb 29, 2012
Review

What's new

v10.0 [Jan 22, 2018]
- Put back the handling of lock_CC_for_rb variable. The variable lock_CC_for_rb should be held per connection.
- Per report from Ayman Samamry.
- Fix SQLGetTypeInfo() so that it filters SQL_TYPE_DATE, SQL_TYPE_TIME or SQL_TYPE_TIMESTAMP for ODBC 2.x applications.
- Per report from Oleg Tonkikh.
- Revise ConfigDSN() so that it handles the 4th parameter(lpszAttribues) correctly.
- Per report from Haribabu Kommi.
- Fix a crash bug when handling error messages. Also modified some error messages.
- Let SQLTables() or SQLTablePrivileges() show partition tables.
- Fix build on Solaris defined(__SUNPRO_C) using Solaris Studio
- Reduce DB access to pg_class or pg_index by caching relhasoids, relhassubclass etc. It would improve the performance of SQLSetPos() or SQLBulkOperations() very much in some cases.
- Per report from Takayuki Tsunakawa.

v9.3 [Nov 2, 2014]
- Ripped out broken retry/timeout logic in SOCK_wait_for_ready.
- Cleaned up Windows makefiles.
- Fixed crash if connection is closed while sending a query to the server.
- Rewrite the conversion functions between strings and SQL_NUMERIC_STRUCT.
- Fixed ODBC function escape for SPACE function.
- Fixed potentially uninitialized local pointer access which causes.
- Fixed ctype_length() is missing the length for SQL_C_BIGINT and SQL_C_NUMERIC.
- Fixed access to unallocated memory in IAsyncPG.
- SQL_NUMERIC_STRUCT was not available until ODBC 3.0.
- Fixed bug in SQLCancel().
- Fixes a NULL pointer dereference occurring when connecting.
- Fixed bug with UseDeclareFetch=1 when a transaction is committed before fetch.
- Fixed driver name mismatch between 32-bit ODBC app and 64-bit MSDTC host.
- Removed PgDtc_set_property(.., prepareRequestded, 0) which causes a crash in case PREPARE TRANSACTION error.
- Added KeepaliveTime and KeepaliveInterval options to specify time or interval for keepalive.
- Fixed a memory leak check qresult.
- Fixed race condition in getting the current decimal separator.
- Fixed bug in building an abbreviated connection string.
- Fixed buffer overflow in SQLGetData.
- The function SC_setInsertedTable() prepares an info for subsequent 'select @@IDENTITY' command.
- Improved pgxalib.dll(MSDTC support).
- Fixed the regkey search bug when XARMcreate() causes an error at enlistmentvin DTC.
- Additonal improvement on MSDTC enlistment.
- Fixed SQLTables column names to be ODBC version 3 compliant.
- Added a new dialog page to the setup program and allow the setting of PREFERLIBPQ and XAOPT option.
- Added a powershell script buildBootStrapper.ps1 which builds bootStrapper program with some optional parameters.

v9.0 [Oct 11, 2010]
- SQLStatistics() sets 'D' for the collation column when an reverse index is used.
- Fix the bug that PostgreSQL's function calls in queries cause a crash on SQL Server linked servers.
- Fix the bug that the first fetch operation doesn't work properly when the operation is SQL_FETCH_ABSOLUTE or SQL_FETCH_LAST.
- Revise the handling of decimal point.
- Adjust the operations after closing eof-detected cursors.
- Clear col_info(columns info) cache ehen DROP/ALTER TABLE is called so that later SQLDescribeCol() etc work properly.
- Improve the handling of BYTEA type.
- Don't clear the columns cache info when they are referenced.
- Correct the column size of interval types.

Alternative downloads

Inno Script Studio
Inno Script Studio
Free
rating

Create scripts to customized Windows installer packages.

Easy HTML To Any Script Converter
Easy HTML To Any Script Converter
Free
rating

Transforms any Html-based code to a script in any other code.

SQL Script Builder
SQL Script Builder
rating

Program which allows to design an SQL script

AzSQL Script Decryptor
AzSQL Script Decryptor
rating

Decrypt encrypted stored-procedures, triggers, views and user defined functions.

Trogon ODBC Database Monitor
Trogon ODBC Database Monitor
rating

World leading ODBC database monitoring tool.