dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi Dapo,

yes agree, we can make sure that the creation of SQL views happens at the
end.

Lars



On Sun, Aug 11, 2013 at 6:52 PM, Dapo Adejumo <dapo_adejumo@xxxxxxxxx>wrote:

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