← Back to team overview

dhis2-devs team mailing list archive

Re: Reaching the limit: 1600 columns (event analytics temp tables)

 

wow!

On Monday, 1 February 2016, Jose Garcia Muñoz <josemp10@xxxxxxxxx> wrote:

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


-- 
*Pierre Dane*

Jembi Health Systems
Software Development Manager
tel: +27 (0)21 701 0939
cel: +27 (0)83 680 8274
email: pierre@xxxxxxxxx
web: www.jembi.org

Follow ups

References