I am trying to migrate my current database from MS SQL to PostgreSQL and while the old database works I want to keep my codebase running on both databases. There is an issue with hierarchyId type which is currently migrated as text in PostgreSQL. I’ve added all missing functions that works with hierarchyID in SQL Server and also added column type mapping in EF, so it wouldn’t break during migration, but there is an issue with mapping functions for PostgreSQL.