Alex Kasko

@rishabhtanwar29 Thanks for the info! I will consider using `--quote-all-identifiers` option with `pg_dump` in scripts/tools.

I believe this was fixed recently by #2931.

@ay27 Thanks for the report! Can you share an example of a MySQL table where this can happen? In general inserts and updates can be more reliable when using `mysql_execute()`...

@ay27 Thanks for the details! Perhaps I am missing something here, but the following insert works for me: ```sql ATTACH 'host=localhost user=root port=3306 database=test_db' AS mysqldb (TYPE MYSQL_SCANNER); INSERT INTO...

I believe this was fixed by #120, `MYSQL_HOST` works correctly for me now. Closing as completed, please comment if it needs to be reopened.

Hi, something like this should work ([reference](https://github.com/babelfish-for-postgresql/babelfish-for-postgresql/wiki/Babelfish-Linked-Servers)): ```tsql exec sp_execute_postgresql 'create extension tds_fdw' exec sp_addlinkedserver @server='babelfish_remote', @provider='SQLNCLI', @datasrc='192.168.178.58:1433' exec sp_addlinkedsrvlogin @rmtsrvname='babelfish_remote', @useself='False', @rmtuser='jdbc_user', @rmtpassword='12345678' select * from openquery(babelfish_remote, 'select pg_backend_pid()')...

@kranthi1385 It looks like your build of Babelfish does not include the support for Linked Servers. You need to build it with FreeTDS lib (`sybdb`) and `tds_fdw` extension included, see...

@kranthi1385 The flag `ENABLE_TDS_LIB` did not come through in your case, you can add it (and `sybdb` lib) in a Makefile instead: ```diff diff --git a/contrib/babelfishpg_tsql/Makefile b/contrib/babelfishpg_tsql/Makefile index f89bdbcf..b03e79c0 100644...

@kranthi1385 Please show your compilation output for `linked_servers.c` file, it should look like this, note that `-DENABLE_TDS_LIB` flag must be present there: ``` gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels...

@kranthi1385 This is the output from compilation of the `tds_fdw` extension. And I was pointing out the [linked_servers.c](https://github.com/babelfish-for-postgresql/babelfish_extensions/blob/38259e3125e6834da4670c650446e30dce2c92b5/contrib/babelfishpg_tsql/src/linked_servers.c) that is a part of `babelfishpg_tsql` extension. Please check that `-DENABLE_TDS_LIB` is...