Postgres Bug Fix ID Conflict

fix_id_conflict.sql

-- What we did to fix this bug, 
-- https://hcmc.uvic.ca/blogs/index.php?blog=22&p=8105&more=1&c=1&tb=1&pb=1

--SELECT MAX(id) FROM pilot;
--SELECT nextval('public.pilot_id_seq');
--SELECT pg_get_serial_sequence('pilot', 'id')
--SELECT nextval('public.pilot_id_seq');

--SELECT setval('public.pilot_id_seq', 13833);

--SELECT MAX(id)+1 FROM pilot;

SELECT setval('public.pilot_id_seq', COALESCE((SELECT MAX(id)+1 FROM pilot), 1), false);

SELECT setval('public.heat_id_seq', COALESCE((SELECT MAX(id)+1 FROM heat), 1), false);
SELECT setval('public.pilot_id_seq', COALESCE((SELECT MAX(id)+1 FROM pilot), 1), false);
SELECT setval('public.asset_id_seq', COALESCE((SELECT MAX(id)+1 FROM asset), 1), false);
SELECT setval('public.avatar_id_seq', COALESCE((SELECT MAX(id)+1 FROM avatar), 1), false);
SELECT setval('public.checkin_id_seq', COALESCE((SELECT MAX(id)+1 FROM checkin), 1), false);
SELECT setval('public.emailblacklist_id_seq', COALESCE((SELECT MAX(id)+1 FROM emailblacklist), 1), false);
SELECT setval('public.frequency_id_seq', COALESCE((SELECT MAX(id)+1 FROM frequency), 1), false);
SELECT setval('public.heatresult_id_seq', COALESCE((SELECT MAX(id)+1 FROM heatresult), 1), false);
SELECT setval('public.installation_id_seq', COALESCE((SELECT MAX(id)+1 FROM installation), 1), false);
SELECT setval('public.laptime_id_seq', COALESCE((SELECT MAX(id)+1 FROM laptime), 1), false);
SELECT setval('public.locationsearch_id_seq', COALESCE((SELECT MAX(id)+1 FROM locationsearch), 1), false);
SELECT setval('public.meetup_id_seq', COALESCE((SELECT MAX(id)+1 FROM meetup), 1), false);
SELECT setval('public.meetupasset_id_seq', COALESCE((SELECT MAX(id)+1 FROM meetupasset), 1), false);
SELECT setval('public.meetupfrequency_id_seq', COALESCE((SELECT MAX(id)+1 FROM meetupfrequency), 1), false);
SELECT setval('public.notification_id_seq', COALESCE((SELECT MAX(id)+1 FROM notification), 1), false);
SELECT setval('public.notificationstream_id_seq', COALESCE((SELECT MAX(id)+1 FROM notificationstream), 1), false);
SELECT setval('public.organizerfrequency_id_seq', COALESCE((SELECT MAX(id)+1 FROM organizerfrequency), 1), false);
SELECT setval('public.pilot_id_seq', COALESCE((SELECT MAX(id)+1 FROM pilot), 1), false);
SELECT setval('public.pilotlocation_id_seq', COALESCE((SELECT MAX(id)+1 FROM pilotlocation), 1), false);
SELECT setval('public.pushmeetupsettings_id_seq', COALESCE((SELECT MAX(id)+1 FROM pushmeetupsettings), 1), false);
SELECT setval('public.pushtemplate_id_seq', COALESCE((SELECT MAX(id)+1 FROM pushtemplate), 1), false);
SELECT setval('public.racegroup_id_seq', COALESCE((SELECT MAX(id)+1 FROM racegroup), 1), false);
SELECT setval('public.racegroupbanner_id_seq', COALESCE((SELECT MAX(id)+1 FROM racegroupbanner), 1), false);
SELECT setval('public.racegroupmember_id_seq', COALESCE((SELECT MAX(id)+1 FROM racegroupmember), 1), false);
SELECT setval('public.role_id_seq', COALESCE((SELECT MAX(id)+1 FROM role), 1), false);
SELECT setval('public.rolemapping_id_seq', COALESCE((SELECT MAX(id)+1 FROM rolemapping), 1), false);
SELECT setval('public.round_id_seq', COALESCE((SELECT MAX(id)+1 FROM round), 1), false);
SELECT setval('public.rsvp_id_seq', COALESCE((SELECT MAX(id)+1 FROM rsvp), 1), false);
SELECT setval('public.timetrialsession_id_seq', COALESCE((SELECT MAX(id)+1 FROM timetrialsession), 1), false);