Today, we are releasing version 2.0.4 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.2+, but it is tested on PostgreSQL 12+.

What's Changed

• Add PostgreSQL15 to the text matrix, and fix PostgreSQL14 by @juliogonzalez in https://github.com/tds-fdw/tds_fdw/pull/320
• Remove PostgreSQL 9.6 and 10 from the CI by @juliogonzalez in https://github.com/tds-fdw/tds_fdw/pull/332
• Clarify usermapping for Azure SQL by @juliogonzalez in https://github.com/tds-fdw/tds_fdw/pull/333
• change pg type to tds type by @maxstarkov in https://github.com/tds-fdw/tds_fdw/pull/327
• Allow use_remote_estimate to be set to 0. by @deathwish in https://github.com/tds-fdw/tds_fdw/pull/335
• Support query cancellation using FreeTDS's cancellation hooks. by @deathwish in https://github.com/tds-fdw/tds_fdw/pull/336
• Fix importing from Sybase schema (float fields) by @vitalca in https://github.com/tds-fdw/tds_fdw/pull/324
• add upgrade route from 2.0.1 to 2.0.3 by @kav23alex in https://github.com/tds-fdw/tds_fdw/pull/339
• Introduce new server option ansi_mode. by @psoo in https://github.com/tds-fdw/tds_fdw/pull/348
• Remove PostgreSQL 11, add PostgreSQL 16 and openSUSE Leap 15.5 by @juliogonzalez in https://github.com/tds-fdw/tds_fdw/pull/353
• Update create_foreignscan_path parameters for PostgreSQL commit 9e9931d2bf by @esiaero in https://github.com/tds-fdw/tds_fdw/pull/358
• Update RHEL and Clones compilation instructions by @juliogonzalez in https://github.com/tds-fdw/tds_fdw/pull/366
• Issue #364: Release 2.0.4 to prepare for PostgreSQL 17 by @GeoffMontee in https://github.com/tds-fdw/tds_fdw/pull/367

New Contributors

• @maxstarkov made their first contribution in https://github.com/tds-fdw/tds_fdw/pull/327
• @deathwish made their first contribution in https://github.com/tds-fdw/tds_fdw/pull/335
• @vitalca made their first contribution in https://github.com/tds-fdw/tds_fdw/pull/324
• @kav23alex made their first contribution in https://github.com/tds-fdw/tds_fdw/pull/339
• @psoo made their first contribution in https://github.com/tds-fdw/tds_fdw/pull/348
• @esiaero made their first contribution in https://github.com/tds-fdw/tds_fdw/pull/358

Full Changelog: https://github.com/tds-fdw/tds_fdw/compare/v2.0.3...v2.0.4

Today, we are releasing version 2.0.3 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.2+, but it is tested on PostgreSQL 9.6+.

New in this version:

• Qualify Sybase tables syscolumns, etc. with owner dbo. See GitHub pull request #267.
• Extend IMPORT FOREIGN SCHEMA for Sybase to Views. See GitHub pull request #266.
• Remove bad pfree of query string. See GitHub pull request #281.
• EXPLAIN (VERBOSE) shows remote query. See GitHub pull request #282.
• Fix tdsReScanForeignScan to actually work. See GitHub pull request #283.
• Add tests for EXPLAIN (VERBOSE). See GitHub pull request #285.
• Make the test scripts compatible with Python 3. See GitHub pull request #286.
• Do not pass dummy relabeling to foreign server. See GitHub pull request #290.
• Fix fetching blob fields larger then 4096 bytes. See GitHub pull request #294.
• debug: include the name in column inner loop. See GitHub pull request #295.
• Add a validator for the JSON files for tests. See GitHub pull request #300.
• Support PostgreSQL 15. See GitHub pull request #315.

Today, we are releasing version 2.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.2+.

New in this version:

• Extended IMPORT FOREIGN SCHEMA to support views. See GitHub pull request #248.

• Fixed improper condition pushdowns. See GitHub issue #253.

• Added support for PostgreSQL 13. See GitHub pull request #261.

Today, we are releasing version 2.0.1 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.2+.

New in this version:

• Improved CentOS installation instructions. See GitHub pull request #194.
• Improved Mac OS X installation instructions. See GitHub pull request #199.
• Changed supported Ubuntu version. See GitHub pull request #206.
• Improved openSUSE installation instructions. See GitHub pull request #208.
• Added support for PostgreSQL 12. See GitHub pull requests #213 and #216.
• Added some testing-related functionality. See GitHub pull request #214.
• Fixed syntax error caused by running IMPORT FOREIGN SCHEMA when the remote schema contained no tables. See GitHub pull request #222.
• Improved Debian installation instructions. See GitHub pull request #231.
• Improved general installation instructions. See GitHub pull request #232.

Today, we are releasing version 2.0.0-alpha.3 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.2+.

This is a pre-release version, so it may not be stable enough to be used in production.

New in this version:

• Adapt to core API changes in PostgreSQL 11. See GitHub pull request #169.
• Fixed a problem with LIKE. See GitHub issue #118.
• Import SQL Server uniqueidentifier data type as PostgreSQL uuid data type. See GitHub pull request #159.
• Allow a comma-separated list for "servername" server option. See GitHub pull request #172.
• Clear error message properly. See GitHub pull request #173.
• Properly initialize a variable in options.c. See GitHub pull request #190 .

Today, I am releasing version 2.0.0-alpha.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.2+.

This is a pre-release version, so it may not be stable enough to be used in production.

New in this version:

• Fix problem accessing INFORMATION_SCHEMA views on case sensitive databases

WARNING: This version does NOT work with PostgreSQL >= 11. For such version use the latest released version of 2.0.0, even if it is still Alpha.

Today, I am releasing version 1.0.8 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:

• Added support for PostgreSQL 9.6. See issue #101.
• Added support for tds_version 7.4 when compiled with a version of FreeTDS that supports that version. See issue #100.

tds_fdw-2.0.0-alpha.1

Today, I am releasing version 2.0.0-alpha.1 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.2+.

This is a pre-release version, so it may not be stable enough to be used in production.

New in this version:

• Removed support for PostgreSQL 9.1.
• Added support for WHERE and column pushdowns. See issue #20.
• Fixed a bug that could cause a crash if the remote table and local table had different definitions. See issue #51.
• Added the following foreign server options: fdw_startup_cost, and fdw_tuple_cost.
• Added the following foreign table options: schema_name, table_name, match_column_names, use_remote_estimate, and local_tuple_estimate.
• Added the column_name column option.

tds_fdw-1.0.7

Today, I am releasing version 1.0.7 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:

• Added support for PostgreSQL 9.5. See issue #49.
• Fixed a bug that made compilation fail on PostgreSQL 9.2. See issue #43.

tds_fdw-1.0.6

Today, I am releasing version 1.0.6 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 some compiler warnings that affected PostgreSQL 9.3 and earlier. See issue #34.
• Fixed a bug in which trailing white spaces were inappropriately truncated by FreeTDS's dbconvert(). See issue #35.
• Fixed a bug where tds_fdw's row count estimates for the planner had a max of INT_MAX. See issue #36.
• tds_fdw constructed tuples with BuildTupleFromCStrings(). It would convert values to C-string using FreeTDS's dbconvert(). This process had a lot of overhead. Now, tds_fdw constructs tuples with heap_form_tuple(). This allows tds_fdw to bypass the C-string conversion step for several data types, and it instead works with raw values. See issue #37.
• Fixed a bug in which binary data would be truncated if a zero byte were encountered. See issue #38.

Thanks to Ken Been (GitHub user @tskenb) for contributing several patches to this release.

Thanks also to Julio González Gil (GitHub user @juliogonzalez) for allowing the tds_fdw project to use his Jenkins continuous integration server.

tds_fdw-1.0.5

Today, I am releasing version 1.0.5 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 an issue that caused problems for versions older than PostgreSQL 9.4. See issue #34.

tds_fdw-1.0.4

Today, I am releasing version 1.0.4 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:

• Added support for PostgreSQL 9.5. See issue #33. Thanks to GitHub user @mc-soi for this patch!
• Fixed several memory leaks. See issue #29.
• Implemented a special conversion for the DATETIME type, so that it can be converted into PostgreSQL's timestamp type without tinkering with the system's locale settings. See issues #28, #21, and #13.
• Added some variables that provide a way to write tds_fdw memory usage to the PostgreSQL error log for diagnostic purposes. These variables are called tds_fdw.show_before_row_memory_stats, tds_fdw.show_after_row_memory_stats, tds_fdw.show_finished_memory_stats.

This version does not support write operations, where push-downs, column push-downs, or join push-downs.

tds_fdw-1.0.3

Today, I am releasing version 1.0.3 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 that made tds_fdw treat empty strings as NULL in some versions of the TDS protocol. See issue #18.
• Added "msg_handler" foreign server option. If set to "notice", DB-Library messages are turned into PostgreSQL notices. If set to "blackhole", DB-Library messages are ignored. By default, "msg_handler" is set to "blackhole." See issue #22.
• Removed "database" foreign table option. Use "database" foreign server option instead.
• The "row_estimate_method" foreign table option can now be set server-wide for a foreign server.
• General code refactoring.

This version does not support write operations, where push-downs, column push-downs, or join push-downs.

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.

tds_fdw-1.0.1

This is version 1.0.1 of tds_fdw, a TDS foreign data wrapper. It can be used to connect to Microsoft SQL Server and Sybase databases. This has been tested on PostgreSQL 9.1 and 9.2, but it should also support 9.3.

This version does not support write operations, added in PostgreSQL 9.3.

tds_fdw-1.0.0

This is version 1.0.0 of tds_fdw, a TDS foreign data wrapper. It can be used to connect to Microsoft SQL Server and Sybase databases. This has been tested on PostgreSQL 9.1 and 9.2, but it should also support 9.3.

This version does not support write operations, added in PostgreSQL 9.3.