I want copy property filed list_price value to product_template list_price2
res_id is product.template,id
insert into product_template (id, list_price2)
select cast(substring(res_id from 18) as int) as id, value_float
from ir_property where name='list_price';
ERROR: null value in column "uom_id" violates not-null constraint
DETAIL: Failing row contains (32645, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 1).