tds_fdw 1.0.6 - Foreign Data Wrapper for MS SQL Server and Sybase - Mailing list pgsql-announce

From Geoff Montee
Subject tds_fdw 1.0.6 - Foreign Data Wrapper for MS SQL Server and Sybase
Date
Msg-id CAA7biFP_Fp5EkR1NRu32PWSpmeE950UYjcmsS9kP9yya92Ss=Q@mail.gmail.com
Whole thread Raw
List pgsql-announce
Hi all,

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.

https://github.com/GeoffMontee/tds_fdw/issues/34

* Fixed a bug in which trailing white spaces were inappropriately
truncated by FreeTDS's dbconvert(). See issue #35.

https://github.com/GeoffMontee/tds_fdw/issues/35

* Fixed a bug where tds_fdw's row count estimates for the planner had
a max of INT_MAX.  See issue #36.

https://github.com/GeoffMontee/tds_fdw/issues/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.

https://github.com/GeoffMontee/tds_fdw/issues/37

* Fixed a bug in which binary data would be truncated if a zero byte
were encountered. See issue #38.

https://github.com/GeoffMontee/tds_fdw/issues/38

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

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.

https://github.com/GeoffMontee/tds_fdw

https://github.com/GeoffMontee/tds_fdw/archive/v1.0.6.zip

https://github.com/GeoffMontee/tds_fdw/archive/v1.0.6.tar.gz

http://pgxn.org/dist/tds_fdw/

Thanks,

Geoff Montee


pgsql-announce by date:

Previous
From: Gary Evans
Date:
Subject: Inaugural Brisbane (Australia) PostgreSQL User Group Meeting
Next
From: David Fetter
Date:
Subject: == PostgreSQL Weekly News - October 25 2015 ==