dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #42871
Reaching the limit: 1600 columns (event analytics temp tables)
Hi devs,
so, it was difficult, but finally we got there. When we run the analytics,
we are getting the following exception
ERROR: tables can have at most 1600 columns; nested exception is
org.postgresql.util.PSQLException: ERROR: tables can have at most 1600
columns
and, yes, we have programs containing above 1600 dataelements,
I'm just writing this email to know if someone here may have a solution for
this, although I'm sure this is a restriction of postgresQL (and in fact,
google says, the only way to change that limit is hacking the core of
postgres...)
Thanks guys
Jose
Follow ups