Bug reference: 16690 Logged by: Mark Phillips Email address: mark.phillips@mophilly.com PostgreSQL version: 12.1 Operating system: Various, see note. Description:
The following query works on... Windows 10 Education Build 1909 18363.1139 PostgreSQL 12.1, compiled by Visual C++ build 1914, 64-bit Mojave 10.14.6 PostgreSQL 12.1 on x86_64-apple-darwin, compiled by Apple LLVM version 6.0 (clang-600.0.54) (based on LLVM 3.5svn), 64-bit
but causes a database connection to be aborted (signal 9) when run on... Catalina 10.15.6 PostgreSQL 12.1 on x86_64-apple-darwin, compiled by Apple LLVM version 6.0 (clang-600.0.54) (based on LLVM 3.5svn), 64-bit
The Query:
Please see if this is still an issue on12.4, since the query shown doesn't do others any good, and you are not running a supported/latest version.