dhis2-devs team mailing list archive

["Dapo Adejumo" <dapo_adejumo@xxxxxxxxx>]

Hi Jason,
Strange.....the sql view was created in DHIS2. Also try clearing the
analytics tables from maintenance.


..........................
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 4:53 PM
To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
Subject: [Dhis2-devs] [Bug 1211010] Re: Analytics tables not generated when
sql views linked to analytics tables exist

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

_______________________________________________
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