Skip to content

Instantly share code, notes, and snippets.

@ewized

ewized/fix_id_conflict.sql

Last active February 8, 2018 01:41
Show Gist options
  • Save ewized/e5c3e95875e19b540af83c301d0445da to your computer and use it in GitHub Desktop.
Save ewized/e5c3e95875e19b540af83c301d0445da to your computer and use it in GitHub Desktop.
Download ZIP
Postgres Bug Fix ID Conflict
Raw
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);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment