openerp-india team mailing list archive

[开阖软件 Jeff Wang <jeff@xxxxxxxxx>]

Public bug reported:

7.0alpha-20121221-154954\Server\server\.\openerp\sql_db.py", line 227, in execute
ProgrammingError: syntax error at or near "with mu"
LINE 2:             with mu as


CREATE OR REPLACE VIEW account_analytic_analysis_summary_user AS (
            with mu as
                (select max(id) as max_user from res_users)
            , lu AS
                (SELECT   
                 l.account_id AS account_id,   
                 coalesce(l.user_id, 0) AS user_id,   
                 SUM(l.unit_amount) AS unit_amount   
             FROM account_analytic_line AS l,   
                 account_analytic_journal AS j   
             WHERE (j.type = 'general' ) and (j.id=l.journal_id)   
             GROUP BY l.account_id, l.user_id   
            )
            select (lu.account_id * mu.max_user) + lu.user_id as id,
                    lu.account_id as account_id,
                    lu.user_id as "user",
                    unit_amount
            from lu, mu)

Somebody said postgresql8.3 in Windows Allinone package don't support
this SQL method, so I advice you package more higher version PGSQL in
the installer, eg, 8.4 or 9.1

No reason to change the code for this.

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

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1094186

Title:
  Error when install account_analytic_analysis module

Status in OpenERP Addons (modules):
  New

Bug description:
  7.0alpha-20121221-154954\Server\server\.\openerp\sql_db.py", line 227, in execute
  ProgrammingError: syntax error at or near "with mu"
  LINE 2:             with mu as

  
  CREATE OR REPLACE VIEW account_analytic_analysis_summary_user AS (
              with mu as
                  (select max(id) as max_user from res_users)
              , lu AS
                  (SELECT   
                   l.account_id AS account_id,   
                   coalesce(l.user_id, 0) AS user_id,   
                   SUM(l.unit_amount) AS unit_amount   
               FROM account_analytic_line AS l,   
                   account_analytic_journal AS j   
               WHERE (j.type = 'general' ) and (j.id=l.journal_id)   
               GROUP BY l.account_id, l.user_id   
              )
              select (lu.account_id * mu.max_user) + lu.user_id as id,
                      lu.account_id as account_id,
                      lu.user_id as "user",
                      unit_amount
              from lu, mu)

  Somebody said postgresql8.3 in Windows Allinone package don't support
  this SQL method, so I advice you package more higher version PGSQL in
  the installer, eg, 8.4 or 9.1

  No reason to change the code for this.

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