1 Answer
- Newest
- Most votes
- Most comments
0
Please let me inform you that Foreign key constraints that reference the database name aren't supported in Babelfish[+]
PostgreSQL has a maximum identifier length of 63 characters, while SQL Server supports up to 128. In addition to this, PostgreSQL has stricter uniqueness requirements for index names. Babelfish handles these restrictions by internally appending or replacing part of such identifiers with a 32-character string representing a hash of the identifier. While this is transparent from T-SQL, the identifier-with-hash is the object name when seen from PostgreSQL.
This is a expected behavior however, please let us know the SQL statements, error messages via support ticket so that we will investigate the issue further.
Relevant content
- asked 3 years ago
- asked 7 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 months ago