weavejester / ragtime

Database-independent migration library
Eclipse Public License 1.0
610 stars 85 forks source link

next-jdbc: Discover that the migration table exists even if the name is quoted #149

Closed holyjak closed 2 years ago

holyjak commented 2 years ago

Currently if I set the migration table name to include quoted schema name, like this (PostgreSQL syntax): "\"myschema\".ragtime_migrations" then Ragtime fails to see that the table exists because it will compare this exact string (including the quotes) against the (str table_schem "." table_name) from the DB Metadata (which will not include quotes).

I need to have the name quoted because my schema begins with a number, which otherwise is not legal.