Description of problem:
The currently packaged version of PostgreSQL JDBC in RHEL7 is not compatible with PostgreSQL 9.6 and later servers, resulting in errors like "column am.amcanorder does not exist".
The upstream fix is at https://github.com/pgjdbc/pgjdbc/pull/560 and https://github.com/pgjdbc/pgjdbc/pull/569
PostgreSQL 9.6 is available from RHSCL
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. use an app that needs/creates indexes with ASC/DESC sorting
ERROR: column am.amcanorder does not exist
please update to 9.4.1209 or later (Fedora has 9.4.1209, upstream is at 42.2.1)
New version of the pgjdbc project has new dependencies, update
to the 42.2.1 would risky and too heavy weight.
(In reply to Pavel Raiskup from comment #2)
> New version of the pgjdbc project has new dependencies, update
> to the 42.2.1 would risky and too heavy weight.
How about an older version, like the one currently in Fedora? Anything newer than 9.4.1209 *should* be good (untested, tho).
Backport for important fixes is always preferred in RHEL. Any update has
some risks (and anything higher than 9.4.1206 brings complex packaging
What can be done to get a new postgres-jdbc rpm to address https://issues.jboss.org/browse/RHPAM-740 ?
These are the repositories we build our openshift images with:
If the rpm could be created included the 9.6 fix noted above (which is less risky and doesn't have the new dependencies that 42.x does), perhaps it could be added to that last repo? "rcm-guest/puddles/RHOM/1.0/latest"?