Postgres Views ProgrammingError more than one row returned subquery
Bug #723355 reported by
Kyle Waid
This bug report is a duplicate of:
Bug #731035: Reference UoM for category should be checked for uniqueness.
Edit
Remove
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Odoo Addons (MOVED TO GITHUB) |
New
|
Undecided
|
Unassigned |
Bug Description
In a sample database you would not notice this issue.
Please issue the following query:
SELECT category_id, COUNT(name) FROM product_uom WHERE uom_type=
GROUP BY category_id; -- HAVING count(name) > 1
If it has any row where count(name) > 1, it will return this error
File "/usr/local/
res = self._obj.
ProgrammingError: more than one row returned by a subquery used as an expression
To bypass the issue do this
It is in addons/
There is another view with a similar problem in the GTK Client warehouse views
To post a comment you must log in.
Actually not the warehouse view, but Purchase > Purchase Analysis