Rob Verschoor
Rob Verschoor
Sounds like your cluster was created in "single-db" mode? If you want to create more than one database, the cluster must be created in "multi-db" mode. You cannot change the...
See the documentation: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/babelfish-create.html
See the other link which I posted above for the standalone setup procedure
It runs really fast for me in 2.1.0, 2.2.0 and 2.3.0. But is it possible that you have a very large number of objects in your database for the case...
Which ALTER DATABASE options would you need? Many of these are very SQL Server specific and will not be relevant in a PG context.
This is a known difference between Postgres/Babelfish and SQL Server. This query assumes that the assignment to the variables is performed in a particular order, i.e `@Suffix` is assigned first...
To add, the [Babelfish Compass tool](https://github.com/babelfish-for-postgresql/babelfish_compass/releases/latest) detects such SELECT statements where a dependency between variable assignments exists, and reports these in the "Review Semantics" category. However, this particular case was...
First off, note that the syntax in the reproduction above is in fact invalid in SQL Server, as ROUND() requires at least 2 arguments (try it). But that aside (just...
MERGE is on the long-term roadmap but **without** any specific timeline. Note that PG15's implementation of MERGE does not fully cover all sides of T-SQL's MERGE. Among other things, PG...
There is no change to PG's support for unsupported MERGE aspects, which is the main issue. Using **Compass -rewrite** remains the best workaround.