tds_fdw 1.0.6 - Foreign Data Wrapper for MS SQL Server and Sybase

From: Geoff Montee <geoff(dot)montee(at)gmail(dot)com>
To: pgsql-announce(at)postgresql(dot)org
Subject: tds_fdw 1.0.6 - Foreign Data Wrapper for MS SQL Server and Sybase
Date: 2015-10-25 16:33:49
Message-ID: CAA7biFP_Fp5EkR1NRu32PWSpmeE950UYjcmsS9kP9yya92Ss=Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-announce by date

  From Date Subject
Next Message Gary Evans 2015-10-26 03:07:02 Inaugural Brisbane (Australia) PostgreSQL User Group Meeting
Previous Message Keith Fiske 2015-10-22 20:07:13 PG Partition Manager v2.2.0 Released