[no description] https://erdgeist.org/gitweb/cccms/atom?h=master 2026-07-11T21:41:29Z 2026-07-11T21:41:29Z erdgeist erdgeist@erdgeist.org 2026-07-11T21:41:29Z urn:sha1:47beb3fe6ed6fdb75c2dd3a55362ad1aba3bbc3b search_vector is populated by a raw Postgres trigger created via execute() in a migration -- invisible to schema.rb, which only represents structure Rails understands. Any database rebuilt from schema.rb rather than replayed migrations (test, a fresh db:setup, disaster recovery) silently lost full-text search entirely, with no error -- NULL @@ anything is never true in Postgres. Page.ensure_search_vector_trigger!, called from an after_initialize initializer, reinstalls the trigger via CREATE OR REPLACE on every boot, in every environment. Idempotent and cheap.