Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
when i try and save a new product i get an Integrity Error : duplicate key value violates unique constraint "product_template_pkey"
this is after importing some products to the DB via SQL to tables poduct_template and product_product.
i dont have any repeated primary key id values in the first column of either table.
where should i be looking for the fault ?
// 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_table_id_seq', (SELECT MAX(id) FROM your_table));
Create an account today to enjoy exclusive features and engage with our awesome community!
Реєстрація
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
Google: 'Sequence-Manipulation Functions'... Using pgAdmin you can view SEQUENCE information via a dialogue box and update the sequence value to equal the next desired record ID.