Hi all. Anyone else run into problems using PostgreSQL 15 with luminus (default migratus library). I'm finding it won't accept anything created in default schema.
the problem is that by default migratus is creating it's "schema_migrations" table in the public schema, and postgres 15 does not accept that https://github.com/yogthos/migratus/blob/master/src/migratus/database.clj#L29
solution, run this when initially creating database:
create schema foo;
grant usage, create on schema foo to appuser;
alter user appuser set search_path to 'foo';This would be a good issue to file on Migratus