-- Create private placeholders for every auth account, including pending users. -- Existing custom profile rows are left unchanged. begin; create or replace function private.ensure_approved_profile() returns trigger language plpgsql security definer set search_path = '' as $$ begin insert into public.community_profiles(user_id,username,display_name,public_profile) values(new.user_id,'member_' || left(replace(new.user_id::text,'-',''),17), 'New member',false) on conflict (user_id) do nothing; return new; end $$; insert into public.community_profiles(user_id,username,display_name,public_profile) select a.user_id,'member_' || left(replace(a.user_id::text,'-',''),17),'New member',false from public.hub_access a on conflict (user_id) do nothing; commit;