Alex Kasko
Alex Kasko
Hi, the last command should work in this form (computing actual index name, see [details in wiki](https://github.com/babelfish-for-postgresql/babelfish-for-postgresql/wiki/Long-identifiers#index-and-constraint-names)): ```tsql IF NOT EXISTS (SELECT TOP 1 1 FROM SYS.INDEXES WHERE NAME =...
Minor correction, to get correct mangled index or constraint name it is necessary to apply `babelfish_truncate_identifier` to index and table names before concatenation: ```tsql select sys.babelfish_truncate_identifier( sys.babelfish_truncate_identifier(lower('idx_or_constraint_name')) + sys.babelfish_truncate_identifier(lower('table_name')) +...
@PauloHMattos portable DB migration scripts for both Babelfish and MSSQL can work reasonably well with current name mangling, see details in these issues - [1](https://github.com/bill-ramos-rmoswi/babelfish_postgresql_towel/issues/14), [2](https://github.com/bill-ramos-rmoswi/babelfish_postgresql_towel/issues/16).
Hi, this example works for me on latest `BABEL_4_X_DEV`, I assume it was fixed in #2275 .
I believe this is fixed with #1905 . In local test I can see `sp_describe_undeclared_parameters` calls go from 14 sec to 0.7 sec with it. It is still noticeably slower...
Hi, please see [this section](https://github.com/babelfish-for-postgresql/babelfish-for-postgresql/wiki/Babelfish-Linked-Servers#adding-babelfish-as-a-linked-server-from-sql-server) of Babelfish Linked Servers doc.
@madanparedla , to connect to Babelfish over ODBC from Linux you need to install Microsoft ODBC Driver 18 for SQL Server and use connection string like this: ``` DRIVER={ODBC Driver...
Hi, I was investigating this metadata issue: > Notice many flags are missing. Out of all flags: - `fNullable` - `fCaseSen` - `usUpdateable` - `fIdentity` - `fComputed` - `usReservedODBC` -...
I believe this is either a duplicate of #1354 or it is closely related. To work around it we were using a [patched version of PyODBC](https://github.com/wiltondb/pyodbc/commit/7252f8874563a4f8c5c58086043765ae50f96161) for some time. Then...
We have a case similar to [this comment](https://github.com/babelfish-for-postgresql/babelfish_extensions/issues/593#issuecomment-1252092882) - there is one service that uses JTDS and it is cumbersome to update it to use mssql-jdbc. After looking into JTDS...