EP-ANALYSIS+: grow the rule set (naming/casing, missing PK, untyped numeric…) #81

Activity

1. ilijevicdenis

   added this to the M7 — SSDT Parity: Engine, Tooling & Coverage milestone on Jun 7, 2026
2. ilijevicdenis

   added

   featureNew capabilityNew capability

   ssdt-paritySSDT-for-PostgreSQL feature-parity effortSSDT-for-PostgreSQL feature-parity effort

   on Jun 7, 2026
3. ilijevicdenis

   added a commit that references this issue on Jun 7, 2026

   feat(analyze): add PG006 (missing primary key) + PG008 (untyped numer…

   ...

   f734255
4. ilijevicdenis commented on Jun 7, 2026

   

   ilijevicdenis

   on Jun 7, 2026

   OwnerAuthor

   More actions

   Added two built-in rules on milestone/m7-ssdt-parity (commit f734255):

   • PG006 — table without a PRIMARY KEY (skips PARTITION OF/typed/LIKE tables whose key comes from elsewhere)
   • PG008 — numeric/decimal column declared without precision/scale

   Both Info severity (non-blocking by default), honour the same enable/severity config, documented in docs/ANALYSIS_RULES.md, tested. Full suite 25,044 pass / 0 fail.

   Leaving this open as the ongoing "grow the rule set" track — further candidates: FK column without a covering index, varchar without length, redundant index, nullable column in a UNIQUE set, etc. (each needs a deliberate add).
5. ilijevicdenis

   added 6 commits that reference this issue on Jun 12, 2026

   feat(analyze): PG010-PG013 type lints + model-level rules with PG014 (#…

   ...

   383a34d

   feat(deploy): lock-minimizing CONCURRENTLY deploy (#137), full publis…

   ...

   5fbd9f1

   docs(progress): backfill commit hash for #81/#137/#140 delivery rows

   ...

   5dc57e8

   feat(analysis): six new analyzer rules PG017/PG019/PG020/PG021/PG024/…

   ...

   278518b

   docs(progress): backfill commit hash for the #81 analyzer-rules deliv…

   ...

   a7e6d65

   Merge milestone/m7-ssdt-parity: #81 analyzer rules (PG017/PG019/PG020…

   ...

   b3c3033