Check and reset primary key sequence for Big South survey_question_options

big_south_seq_reset.sql

-- find highest ID value
SELECT MAX(id) FROM survey_question_options;

-- check next value in auto-incrementing sequence
SELECT nextval('survey_question_options_id_seq');

-- if they are not in sync, reset sequence at highest ID + 1
SELECT setval('survey_question_options_id_seq', (SELECT MAX(id) FROM survey_question_options)+1);