openerp-community-reviewer team mailing list archive

["Andrius Preimantas @ hbee" <andrius.preimantas@xxxxxxxxx>]

Public bug reported:

Addons revno 10181

SQL view created for report _name = 'report.stock.lines.date' is not
supported by Postgresql 9.0 or older.

That's what I've found out:
* Revision 10142 added a new field for this SQL view "active" (ref: http://bazaar.launchpad.net/~ocb/ocb-addons/7.0/revision/10142#stock/report/report_stock.py)
* Postgresql version 9.0 and older does not support referring to a column which is not in group by clause if this clause is present (ref: http://www.postgresql.org/docs/9.0/static/sql-select.html#SQL-GROUPBY)

Please find patch attached.

Cheers
Andrius

** Affects: ocb-addons
     Importance: Undecided
         Status: New

** Patch added: "report.patch"
   https://bugs.launchpad.net/bugs/1319444/+attachment/4112404/+files/report.patch

-- 
You received this bug notification because you are a member of OpenERP
Community Backports, which is subscribed to OpenERP Community Backports
(Addons).
https://bugs.launchpad.net/bugs/1319444

Title:
  [7.0][ocb-only] Report "report.stock.lines.date" not supported by
  postgresql < 9.1

Status in OpenERP Community Backports (Addons):
  New

Bug description:
  Addons revno 10181

  SQL view created for report _name = 'report.stock.lines.date' is not
  supported by Postgresql 9.0 or older.

  That's what I've found out:
  * Revision 10142 added a new field for this SQL view "active" (ref: http://bazaar.launchpad.net/~ocb/ocb-addons/7.0/revision/10142#stock/report/report_stock.py)
  * Postgresql version 9.0 and older does not support referring to a column which is not in group by clause if this clause is present (ref: http://www.postgresql.org/docs/9.0/static/sql-select.html#SQL-GROUPBY)

  Please find patch attached.

  Cheers
  Andrius

To manage notifications about this bug go to:
https://bugs.launchpad.net/ocb-addons/+bug/1319444/+subscriptions