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
