dhis2-devs team mailing list archive

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

No, you are absolutely right and I jumped the gun. The views are
recreated after the resource table regeneration, and prior to the
regeneration of the analytics tables. This step (regeneration of the SQL
views) needs to occur after the analytics tables are populated.

-- 
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:
  Confirmed

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