tds_fdw-1.0.2
Today, I am releasing version 1.0.2 of tds_fdw, a TDS foreign data wrapper. It can be used to connect to Microsoft SQL Server and Sybase databases. This should work on PostgreSQL 9.1+.
New in this version:
- Fixed bug causing negative row count estimations in query plans. See issues #14 and #15.
- Added database and dbuse options to foreign server objects. This also fixes issues with Microsoft Azure. See issues #23.
- Added tds_version option to foreign server objects. See issue #24.
- Added row_estimate_method option to foreign table objects. Default value is execute. If set to execute, tds_fdw will execute a query on the remote table and count the number of rows used to build the query plan. If set to showplan_all, tds_fdw will use MS SQL Server's SET SHOWPLAN_ALL feature to get the estimated the number of rows used to build the query plan. I hope to add a Sybase optimization eventually.
- General code refactoring, mostly related to options and row estimations.
This version does not support write operations, predicate push-downs, or join push-downs.