Function warnOnInvalidIndexes

packages/db/scripts/migrate.ts:215–233

* A failed CONCURRENTLY build leaves an INVALID index that `IF NOT EXISTS` * silently skips forever — surface it (warn only; the migration committed).

()

 * silently skips forever — surface it (warn only; the migration committed).
 */
async function warnOnInvalidIndexes(): Promise<void> {
  try {
    const rows = await client`
      SELECT n.nspname AS schema, c.relname AS index
      FROM pg_index i
      JOIN pg_class c ON c.oid = i.indexrelid
      JOIN pg_namespace n ON n.oid = c.relnamespace
      WHERE NOT i.indisvalid
    `
    for (const row of rows) {
      console.warn(
        `WARN: invalid index ${row.schema}.${row.index} — a CONCURRENTLY build failed partway. ` +
          'Drop and rebuild it; IF NOT EXISTS will keep skipping it.'
      )
    }
  } catch (checkError) {
    console.warn('WARN: could not check for invalid indexes.', checkError)
  }
}

/**
 * Unlock errors are swallowed: the session lock auto-releases on disconnect,