Hello community,
I am trying to archive multi databases using postgresql + custom schema (not public), but the current behaviour feels confusing to me.
For example, rails db:create runs DATABASE CREATE based on this source, after this if i set a different schema_search_path in database.yml (such like this), it will raise, because we don’t have any mention of creation of schema.
At the moment, it seems that the only solution is to extend tasks like db:create, db:prepare, or similar, and manually create the schemas based on ActiveRecord::Base.configurations.
Am I missing something here? How do you usually handle this scenario in your projects?