On Fri, Oct 6, 2017 at 11:48 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Lucas Fairchild-Madar <lucas.madar@gmail.com> writes: > I'm experiencing this on 9.6.
Oh, hmm, it's something else in that case. Can you put together a more self-contained test case? This sort of thing isn't usually very data-dependent, so you could probably make a test case with dummy data.
regards, tom lane
Sure, here's a bash script. Assumes you have PGDATABASE, etc set.
Verified this also blows up on pg 10. I haven't verified the new patch.
#!/bin/bash
ITEMS=100000
FILE=kaboom.sql
echo -n "{\"id\":\"foo\",\"items\":[" > $FILE
for i in $(seq 1 $ITEMS); do
echo -n "{\"item\":$i,\"data\":\"The quick brown cow jumps over the lazy sloth\"}," >> $FILE