On 3/28/19 8:49 AM, Alexander Korotkov wrote: > >> Here's an interesting data point. If I run the whole jsonpath.sql script >> it crashes every time. If I run just the offending statement it crashes >> exactly every other time. It looks like in that case something gets >> clobbered and then cleared. > Could you clarify this a bit? What is exactly every other time? Do > you mean it doesn't crash first time, but crashes second time? Do you > run each offending statement in the separate session? Or do you run > multiple offending statements in the same session? >
I mean repeated invocations of psql -c "select '$ ? (@ like_regex \"pattern\" flag \"a\")'::jsonpath" These get crash, no crash, crash, no crash ... cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services