On 2/8/20 12:09 PM, Nick Renders wrote:
Hi,
We have just upgraded our Postgres 9.6 database to 12.1 (pg_dumpall ->
pg_restore on a clean installation) and now we are having some issues
with one of our tables.
When we do the following statement:
SELECT * FROM f_gsxws_schedule WHERE UPPER(gwsc_dossier) = 'TEST'
the Postgres service restarts.
It seems that using UPPER() in the WHERE clause is causing this. The
same statement without UPPER() works just fine.
I have tried to emulate the issue with other tables, but
f_gsxws_schedule seems to be the only one.
The table also has another character field that is indexed, and the same
problem occurs there. Whenever we use UPPER() or LOWER() to do a
case-insensitive search, the service reboots.
Looking at the table's definition, I don't see anything different with
the other tables.
Here is what is logged:
Has anyone noticed anything like this before? Any idea how to fix this?
Was the upgrade on the same machine?
Or was the machine also upgraded/updated?
I ask as there have been similar reports having to with changes in glibc
version affecting collation.
Best regards,
Nick Renders
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
