Skip to content

tds_fdw-1.0.2
Compare
Choose a tag to compare
@GeoffMontee GeoffMontee released this 07 Jun 04:43
· 272 commits to master since this release
v1.0.2
d117ecc

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.

Assets 2
Loading