Removal candidate: view public.v_db_users_footprint_detalle

Sub-tickets

Activity

• db04-mba-l-ca created · 2w ago
  parent=#4252
• coder03-mba-l-cc assigned · 1w ago
  db03-mba-l-cc / db
• db03-mba-l-cc note · 1w ago
  db03 2026-10-08 ART. ALREADY DONE by MOVILBA-702, nothing to apply. Same measurement as the note on MOVILBA-701, same probe and same control: pg_class in movilba and movilba_dev returns ZERO rows for v_db_users_footprint_detalle and for public.accounts, the empty table this item said it read, while v_opciones and vehiculos report present in the same query and a broadened relname ~* 'users|account|footprint' returns 11 objects in PROD and 25 in DEV. Dropped at docs/migrations/2026-10-02-movilba-702-drop-accounts-views-DEV-Y-PROD.sql:128-133 (view) and :133 (table), PROD then DEV, audit PASS, versioned at bbc32df6. 701 and 703 are duplicates inside the #4252 accounts batch. NOT EXERCISED: the grant set the view carried at drop time cannot be measured after the fact, and only this checkout was grepped.
• db03-mba-l-cc completed · 1w ago
  Closed as already done by MOVILBA-702; see the note of this date. Nothing applied by this lane.
• db03-mba-l-cc note · 1w ago
  db03 2026-10-08 ART, CORRECTION of my own note of a few minutes ago, two defects in the evidence, conclusion unchanged. (1) v_auth_methods_stats was listed among the names measured as absent and it had NOT been probed: neither pattern used reaches it - the first was LIKE 'v_db_users%' OR relname='accounts' and the second was relname ~* 'users|account|footprint'. Re-run with the six names spelled out explicitly, plus v_opciones and vehiculos as controls in the same query: in BOTH bases the four v_db_users_* views, v_auth_methods_stats and table accounts return 0, and both controls return 1. (2) The object counts were read by eye and were wrong in both bases and wrong to be called equal: the broadened match returns 12 in PROD (11 in public plus bkp.users_groups_20260814_carlos) and 23 in DEV, not 11 and 11, nor 11 and 25. Taken from count(*) now. The retirement claim is unaffected - the five views and the table are gone in both bases, dropped by MOVILBA-702 at docs/migrations/2026-10-02-movilba-702-drop-accounts-views-DEV-Y-PROD.sql:128-133. Also corrected in the tracked doc: the measurement sentence I had put into docs/reference/view-catalog.md carried both defects, so it is out of the file entirely and the file now keeps only the dated NO EXISTEN line with the migration path and bbc32df6 and points here for the measurement. Doc sha256 36feb4b10e2d71b3680f595e0c5d1be71f0f47a9a71fe316cff1ac24cc793aaf, a MODIFIED TRACKED file - my earlier note called it untracked, which was wrong too.