-- Create a security definer function to fetch a glider by ID CREATE OR REPLACE FUNCTION public.fetch_glider_by_id(p_glider_id TEXT) ...

-- Create correct partial unique index: only one primary per glider CREATE UNIQUE INDEX IF NOT EXISTS unique_primary_per_glider ...