dhis2-devs team mailing list archive

["Dapo Adejumo" <dapo_adejumo@xxxxxxxxx>]

Thanks Jason...glad you found it :) - the sequence needs to be changed.


..........................
Regards

Dapo Adejumo
+2348033683677
Skype : dapojorge


-----Original Message-----
From: Dhis2-devs
[mailto:dhis2-devs-bounces+dapo_adejumo=yahoo.com@xxxxxxxxxxxxxxxxxxx] On
Behalf Of jason.p.pickering
Sent: Sunday, August 11, 2013 5:14 PM
To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
Subject: [Dhis2-devs] [Bug 1211010] Re: Analytics tables not generated when
sql views linked to analytics tables exist

Well, you are right Dapo. I thought I was all clever, but did not look
through the entire log. :/ The process does fail, because the SQL views
are not being dropped prior to the creation of the analytics tables.
Looks like this needs to occur after their creation and not after the
creation of the resource tables.


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

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

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp