Geoff Montee

This sounds like a character set might be incorrect somewhere. There are a few different places to check for character set mismatches when using tds_fdw: 1.) When you are using...

What does your freetds.conf file look like? Do you set `tds_version` for the foreign server? What is the character set that the PostgreSQL database is configured to use?

Can you please show what your freetds.conf looks like?

Hi @bradleyf, I'm not sure if I'll get around to this change, but if anyone else wants to submit a pull request with the change, I'd gladly review it.

Please set `remote_estimate_method` for the table to `showplan_all` to avoid this problem on MS SQL Server. https://github.com/tds-fdw/tds_fdw/blob/master/ForeignTableCreation.md

Hi @donnorman, > So on the SQL server (2008) the field is `datetime`, but in the foreign table definition I made the field `timestamptz`. This is because I am translating...

> Thanks for the very detailed response, I appreciate it! No problem! Thanks for using tds_fdw! > Which now returns `2015-11-02 11:15:29.437-05`. And I believe that is showing me the...

The `2.0.0-alpha1` release is a few commits behind `master` right now, so it is missing some fixes. Does `master` have this problem for you? It seems to work as expected...

Hi @Loriowar, I'm not entirely sure what is causing this problem. WHERE and column pushdowns aren't even performed when using the `query` foreign table option. Would you be willing to...

Sorry, can you please clarify? Is the column name turning to gibberish, or is the column's value turning to gibberish, or are both turning to gibberish? If the column name...