Geoff Montee

Results 102 comments of Geoff Montee

Yeah, set `msg_handler` to `notice`. See here: https://github.com/tds-fdw/tds_fdw/blob/master/ForeignServerCreation.md

Yeah, it might be possible to save notices, and then print them whenever an error is thrown. The problem is that FreeTDS generates a *lot* of messages, and it is...

*Connection refused* generally means either that nothing is listening on the port or that some firewall is blocking access. https://serverfault.com/questions/725262/what-causes-the-connection-refused-message

Hi @smarmet, Some notes: 1.) tds_fdw can take too long to plan queries with `row_estimate_method=execute`. Try setting `row_estimate_method=showplan_all` for the table. Or you can disable remote estimates during planning by...

``` I believe where clauses are propagating correctly, as more restrictive queries do return faster. ``` We can confirm that `WHERE` pushdown is occurring by setting the log level to...

> WARNING: Table definition mismatch: Could not match local column "Value" with column from foreign table. If I remember correctly, I don't think this warning always indicates a problem with...

Oh, I see. Sorry for the confusion. It's good to know that the query was printed, and that the query did include the `WHERE` clause. So far, it sounds like...

Hi @jcarnu , > the IMPORT SCHEMA should take care of the possible inexistance of tables in the corresponding schema Yeah, I agree. We should probably add a check right...

Not at the moment. If anyone else would like to try implementing it, pull requests would be most welcome.

@select-artur contributed a patch that implements IMPORT FOREIGN SCHEMA. It has been merged into master if anyone would like to test it.