tds_fdw-2.0.4

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

New Contributors

• @maxstarkov made their first contribution in #327
• @deathwish made their first contribution in #335
• @vitalca made their first contribution in #324
• @kav23alex made their first contribution in #339
• @psoo made their first contribution in #348
• @esiaero made their first contribution in #358

Full Changelog: v2.0.3...v2.0.4

tds_fdw-2.0.3

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.

tds_fdw-2.0.2

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.

tds_fdw-2.0.1

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.

tds_fdw-2.0.0-alpha.3

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 .

tds_fdw-2.0.0-alpha.2

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

tds_fdw-1.0.8

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

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

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

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.