Postgresql

Error: duplicate key value violates unique constraint:
-- Login to psql and run the following
-- What is the result?
SELECT MAX(id) FROM your_table;

-- Then run...
-- This should be higher than the last result.
SELECT nextval('your_table_id_seq');

-- If it's not higher... run this set the sequence last to your highest pid it. 
-- (wise to run a quick pg_dump first...)
SELECT setval('your_tables_id_seq', max(id)) FROM your_tables;

-Reset AutoIncrement
TRUNCATE TABLE someTable RESTART IDENTITY;