Skip to Content
This question has been flagged
postgresqlsql
1 Reply
5138 Views
Avatar
Ron

I was migrating my openerp database from one server to another. And while restoring database on another server I am geting this error

ALTER TABLE ERROR: insert or update on table "stock_move" violates foreign key constraint "stock_move_product_id_fkey" DETAIL: Key (product_id)=(2466) is not present in table "product_product". ALTER TABLE

Please Suggest !!

Avatar
Discard
Avatar
Nehal
Best Answer

You might not have the Product with id = 2466 in the product_product table which is used as foreign key in stock_move table. You can create product with id = 2466 in product_product as a solution.

Avatar
Discard
Related Posts Replies Views Activity
Getting Error while restoring Openerp database
postgresql sql
Avatar
0
Mar 15
2848
Getting Error while restoring Openerp database
postgresql sql
Avatar
0
Mar 15
3212
How do I view PostgreSQL logs? Solved
postgresql log sql
Avatar
Avatar
1
Feb 18
10162
When Odoo 14 connects to PostgreSQL 15.7, the connection is idle but cannot be released
postgresql
Avatar
0
Feb 25
795
psycopg2.OperationalError: connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied
postgresql
Avatar
Avatar
Avatar
2
Jan 25
6873