Labkey pivot query limit

LabKey Support Forum (Inactive)
Labkey pivot query limit Jon (LabKey DevOps)  2016-06-03 14:35
Status: Closed
 
Hi Kristen,

It's a little bit of Postgres, but it is also somewhat caused by the user.

Postgres has a hard limit of 1664 columns, so if you try to go past that in anyway, you will see the same error appear.

Generally, the best way to work this is to try and reduce the number of columns as you need.

Regarding your data, do you need to have all 2000 columns listed?

Regards,

Jon