Hi Folks, Tops to you this day. I imported accounts (account_account) directly from pgadmin. Afterwards I tried to create a new account from OpenERP, when I try to save,I get the following error message
"duplicate key value violates unique constraint "account_account_pkey" DETAIL: Key (id)=(114) already exists."
Apparently before I imported the accounts from pgadmin, the next in line pkey was 114, I manually assigned this as a database id for one of the imported accounts but somehow the system does not consider the manually assigned database id (assigned during my pgadmin import). I imagine it stores OpenERP assigned database ID some where so I need to go and update that to read the actual last database id based on my assigned values.
Does anyone know where that it is stored or how I can achieve that?
many thanks in advance for your help.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 5/6/13, 6:35 AM|
|Seen: 1521 times|
|Last updated: 3/16/15, 8:10 AM|