-- WE can just drop the type with a cascade
SET search_path = public;

DROP TYPE pgrowlocks CASCADE;