c2c-oerpscenario team mailing list archive

[Martin Collins <839915@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

I am creating database views as a basis for reports. I've done three
that work fine. The fourth does not. When I click on its menu item I get
this error:

ProgrammingError: relation "citrus_fruit_received_report" does not exist
LINE 1: SELECT "citrus_fruit_received_report".id FROM "citrus_fruit_...

Sure enough, the view is not in the database.
Now I've gone through my code, the query works fine in pgadmin, if I make _auto=True I get a working object, the field names and types all match.

Stepping through in the debugger I see that the view is created in the
database but then it gets dropped again. I cannot see why, or how. What
could cause this?

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

-- 
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/839915

Title:
  Database views fail silently on function fields

Status in OpenERP Server:
  New

Bug description:
  I am creating database views as a basis for reports. I've done three
  that work fine. The fourth does not. When I click on its menu item I
  get this error:

  ProgrammingError: relation "citrus_fruit_received_report" does not exist
  LINE 1: SELECT "citrus_fruit_received_report".id FROM "citrus_fruit_...

  Sure enough, the view is not in the database.
  Now I've gone through my code, the query works fine in pgadmin, if I make _auto=True I get a working object, the field names and types all match.

  Stepping through in the debugger I see that the view is created in the
  database but then it gets dropped again. I cannot see why, or how.
  What could cause this?

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