Re: Postgres 12.1 : UPPER() in WHERE clause restarts server

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nick Renders" <postgres(at)arcict(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres 12.1 : UPPER() in WHERE clause restarts server
Date: 2020-02-24 15:24:08
Message-ID: 18276.1582557848@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Nick Renders" <postgres(at)arcict(dot)com> writes:
> We have set up a new test environment running PostgreSQL v12.2 on macOS
> 10.14 and the issue is still there.

Some nearby threads prompt these two questions:

1. Are you using your own build, or is this from EDB's installer?

2. If the latter, does turning JIT off ("set jit = off") make the
problem go away?

There is as yet no "native" support for --with-llvm on macOS,
ie Apple themselves don't provide sufficient support for that.
EDB seem to have hacked up something that sort of works, but
only sort of.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bvo 2020-02-24 15:50:34 Re: backup broken
Previous Message bvo 2020-02-24 15:23:43 backup broken