No idea how my db table sequence got out of wack, but here's how I solved this:
-----------------------------------------------------------------------------------------------------------------------------------
-- RESET DB TABLE ID SEQUENCE
-----------------------------------------------------------------------------------------------------------------------------------
-- Get pg_vector's sequence name
SELECT pg_get_serial_sequence('data_pg_vector_store', 'id'); -- `public.data_pg_vector_store_id_seq`
-- Check the next value of the sequence
SELECT nextval('public.data_pg_vector_store_id_seq') - 1; -- 93735 (Problem identified!)
-- Double check settings
SELECT * FROM public.data_pg_vector_store_id_seq;
-- Returns:
-- last_value log_cnt is_called
-- 93736 32 TRUE
-- Double check latest values
SELECT id FROM data_pg_vector_store ORDER BY id DESC LIMIT 10; -- 191161
-- Reset the sequence to be +1 more than the last ID value
SELECT setval('public.data_pg_vector_store_id_seq', COALESCE((SELECT MAX(id)+1 FROM data_pg_vector_store), 1), false); -- 191162 --> Set the sequence to start from 191162
-- SUCCESS!