-- PostgREST executes STABLE RPCs in a read-only transaction. Customer access
-- checks take a shared row lock and may synchronize expired temporary KYC.
-- Keep those authoritative checks, but allow their required transaction mode.
-- Admin reads only inspect membership and ticket data and remain STABLE.
begin;
alter function public.marketplace_ticket_list(jsonb) volatile;
alter function public.marketplace_ticket_detail(uuid) volatile;
notify pgrst,'reload schema';
commit;