Hi, I am on ktor 1.5.2 and I am having issues with...

# exposed

[Luca Sas]

Hi, I am on ktor 1.5.2 and I am having issues with SchemaUtils.create. I have 3 tables, and the third has a reference to the first one. When it gets to creating the third table it concludes that the first one doesnt exist and tries to create it again which causes an error "relation "users_username_unique" already exists".

I debugged and stepped thru the code and found that the problem is in VendorDialect.tableExists function.

override fun tableExists(table: Table): Boolean {
        val tableScheme = table.tableName.substringBefore('.', "").takeIf { it.isNotEmpty() }
        val scheme = tableScheme?.inProperCase() ?: TransactionManager.current().connection.metadata { currentScheme }
        val allTables = getAllTableNamesCache().getValue(scheme)
        return allTables.any {
            when {
                tableScheme != null -> it == table.nameInDatabaseCase()
                scheme.isEmpty() -> it == table.nameInDatabaseCase()
                else -> it == "$scheme.${table.tableNameWithoutScheme}".inProperCase()
            }
        }
    }

What happens here by looking at the debugger is that alltables is [ "public.tablename", "public.someothertablename" ] but table.name misses the schema name and I am not sure why. The code is fairly straightforward and I used SchemaUtils.create successfully in the past.

[tapac]

Can you share a sample project on github to test?