household_deficiency_afe_aggregation not updated in refreshAllMaterializedViews call

[bgsandan]

• After CI execution the view is empty:

• When explicitly calling refreshAllMaterializedViews function the view is not updated (the other 9 are):

• Explicitly refreshing the view works:

[bgsandan]

cc: @rbroth - weird behaviour here!

[rbroth]

Is the view created in teh correct schema? I've had problems of db objects accidentally being created in the public schema

[bgsandan]

Yup, top screenshot is the view of all materialized views in the bmgf schema

[bgsandan]

This line is the culprit https://github.com/micronutrientsupport/database-architecture/blob/346dde7aa1a3e4f48cc2394bacdc567847384f25/db/objects/R__105__RefreshAllMaterializedViews.sql#L15 🤦