View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0003397||SymmetricDS||Bug||public||2018-01-31 21:19||2019-04-23 15:41|
|Target Version||3.10.1||Fixed in Version||3.10.1|
|Summary||0003397: Using Postgresql 9.6.6 as a Source DB Fails SymmetricDS Upgrade to version 3.9.2 due to old postgresql jdbc driver|
|Description||This Version of the JDBC Driver has a Issue with PostgreSql verion 9.1 and above in that when it accesses the Postgresql Catalog table pg_trigger in order to look up Catalog Metadata AND it selects a non existant column pg_trigger.tgisconstraint which was dropped from PostgreSQL in Version 9.2 and Above.|
I know of this issue specifically when I tried to do a SymmetricDS Upgrade as during the upgrade I assume the SymmetricDS Code is using JDBC Methods which fail with the error
t1.tgisconstraint does not exist.
This is Due to Postgresql Removing this column from the catalog with the release of Postgresql 9.2.4
As Such We replaced the postgresql-9.4-1212.jre7.jar found within the SymmetricDS released lib directory with the Current PostgreSQL JDBC Driver postgresql-42.1.4.jar which works with PGSQL 9.2 and above and no longer references t1.tgisconstraint within the JDBC Driver's methods.
So Please replace the PostgreSQL JDBC driver released with the SymmetricDS to be the Current Version postgresql-42.1.4.jar or whatever the most Current Postgresql JDBC Driver at the Time of Repair of this Issue.
I know that each installation can Supply there own JDBC Drivers, however it would be better to not supply Any JDBC Driver with the Symmetric Release instead of a JDBC Driver which causes Issues in Performing Upgrades.
|Steps To Reproduce||Use Symmds 9.4.2 to upgrade from any Prior Symmds Release using either the Source or Target node being Postgresql version 9.4 and above.|
|Tags||dialect: postgresql, upgrade|
|2018-01-31 21:email@example.com||New Issue|
|2018-01-31 21:firstname.lastname@example.org||Tag Attached: postgresql|
|2018-01-31 21:email@example.com||Tag Attached: tgisconstraint|
|2018-01-31 21:firstname.lastname@example.org||Tag Attached: Upgrade|
|2019-04-12 16:33||admin||Tag Detached: tgisconstraint|
|2019-04-23 12:24||elong||Assigned To||=> elong|
|2019-04-23 12:24||elong||Status||new => resolved|
|2019-04-23 12:24||elong||Resolution||open => fixed|
|2019-04-23 12:24||elong||Fixed in Version||=> 3.10.1|
|2019-04-23 12:24||elong||Target Version||=> 3.10.1|
|2019-04-23 15:41||elong||Status||resolved => closed|
|2019-04-23 20:50||admin||Tag Renamed||postgresql => dialect: postgresql|