supabase / supautils / 29938831770

92%

Build Type

push

github

Committed by web-flow

Commit Message

feat: gate version restriction behind supautils.restrict_extension_versions

Adds an enum GUC (default 'off', PGC_SUSET) controlling the CREATE/ALTER EXTENSION version restriction:

- off:   no restriction (default), existing deployments unaffected
- warn:  the specified version is ignored with a WARNING and the
         extension's default_version is used instead
- error: the statement is rejected

The warn mode allows a graceful rollout: statements keep working while
the warnings measure how many clients actually specify versions, before
switching the fleet to error.

Also reworks restrict_version_specification() per review:
- takes extension_stmt_kind (same discriminator as override_ext_options)
  instead of a stringly-typed stmt_type
- returns the options list, stripping every new_version DefElem in warn
  mode (all occurrences, so duplicate VERSION clauses can't slip through)

Tests cover all three modes on both the privileged and non-privileged
extension paths, plus GUC validation, and pass on PG 13-18.

Coverage Stats

20 of 22 new or added lines in 1 file covered. (90.91%)

38 existing lines in 1 file now uncovered.

1183 of 1292 relevant lines covered (91.56%)

55.84 hits per line