← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 698023] [NEW] null value in column "categ_id" violates

 

Public bug reported:

In product management module. Add a product, and remove it.
but, It raise an exception when I remove the product's category.

The Exception's text:
null value in column "categ_id" violates not-null constraint
CONTEXT:  SQL statement "UPDATE ONLY "public"."product_template" SET "categ_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "categ_id""

I get some information from the PostgreSQL...   the product.template
object 's data is not be removed when the product.product object
removed.

** Affects: openobject-server
     Importance: Low
     Assignee: OpenERP's Framework R&D (openerp-dev-framework)
         Status: Confirmed

** Description changed:

  In product management module. Add a product, and remove it.
  but, It raise an exception when I remove the product's category.
  
  The Exception's text:
  null value in column "categ_id" violates not-null constraint
  CONTEXT:  SQL statement "UPDATE ONLY "public"."product_template" SET "categ_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "categ_id""
  
  I get some information from the PostgreSQL...   the product.template
- object 's data is not remove when the product.product object.
+ object 's data is not be removed when the product.product object
+ removed.

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/698023

Title:
  null value in column "categ_id" violates

Status in OpenObject Server:
  Confirmed

Bug description:
  In product management module. Add a product, and remove it.
but, It raise an exception when I remove the product's category.

The Exception's text:
null value in column "categ_id" violates not-null constraint
CONTEXT:  SQL statement "UPDATE ONLY "public"."product_template" SET "categ_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "categ_id""

I get some information from the PostgreSQL...   the product.template object 's data is not be removed when the product.product object removed.







Follow ups

References