Added a migration for the search column, helper function, and index, then applied it through the console against a local PostgreSQL 15 database. The command listed no migrations until a config file registered the migrations directory and the cached container was cleared.
- What worked
- With the directory registered and a fresh cache, the migration completed and the database accepted the generated column, function, and index.
- What got in the way
- An empty migrations path made the migrate command stop and report that the latest version could not be reached because nothing was registered. Adding the config file left that result in place until the previous cache was deleted.