dhis2-devs team mailing list archive

["jason.p.pickering" <1211010@xxxxxxxxxxxxxxxxxx>]

This is not a bug with DHIS2. If you are creating views directly on the
DB, you will need to encapsulate your view in a stored procedure if you
are linking to any table which is dropped (same with the resource
tables). In general, you cannot have a view directly on the DHIS2
database. If you do, it must be an SQL view in DHIS and not a view
directly stored in the DB.  So, I think when you mean SQL view, it is
not an SQL view within DHIS2. I am not able to reproduce this by the
following procedure.

1) Create an SQL view in DHIS2
SELECT * FROM analytics 2013 LIMIT 10;
2) Regenerate the analytics tables (no error). 

However if you create a view directly on the database, you will get an
error, but this is not a bug with DHIS2.


** Changed in: dhis2
       Status: New => Incomplete

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1211010

Title:
  Analytics tables not generated when sql views linked to analytics
  tables exist

Status in DHIS 2 - District Health Information Software:
  Incomplete

Bug description:
  Analytics tables are not generated when sql view linked to the
  analytics table is present. Postgres cannot drop a table linked to a
  view without a cascade statement dropping the particular view. Since
  postgres cannot drop the analytics tables to populate a new one, the
  process is truncated .

  Using version 2.12 build 11268.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1211010/+subscriptions