Re: array size exceeds the maximum allowed (1073741823) when building a json

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tue, Jun 7, 2016 at 7:44 AM, Nicolas Paris <niparisco@xxxxxxxxx> wrote:

Hello,

I run a query transforming huge tables to a json document based on a period.
It works great for a modest period (little dataset). 
However, when increasing the period (huge dataset) I get this error:

SQL ERROR[54000]
ERROR: array size exceeds the maximum allowed (1073741823)

​https://www.postgresql.org/about/​

​Maximum Field Size: 1 GB​

​It doesn't matter that the data never actually is placed into a physical table.

David J.