Uploaded image for project: 'ROOT'
  1. ROOT
  2. ROOT-9550

last ROOT versions don't support PostgreSQL less than 10.x

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 6.12/06, 6.14/00
    • Fix Version/s: 6.16/00, 6.14/02
    • Component/s: I/O, Other
    • Labels:
      None
    • Environment:

      Ubuntu 18.04 gcc 7.3.0, CentOS 7 gcc 4.8.5

      Database Server: PostgreSQL 8.4

      Description

      Hello,

      We are going to update the ROOT version for our experiment software MpdRoot but I have discovered that the last ROOT versions support PostgreSQL clients v. 10.x only as decribed in the commit below (may be 10.x client doesn't work also but i can't check).

      I tried to make queries to the experiment database from Ubuntu 18.04 with the last libpqxx-dev library (4.0.1+dfsg3-8) and from CentOS 7.4 with postgresql-devel (9.2.23-3) but I got the following message:

      Error in <TPgSQLServer::Statement>: not implemented for pgsql < 8.2

      It is occurred because of this commit :

      #include "TSQLStatement.h"
       ...
      -#include <pg_config.h> // to get PG_VERSION_NUM
      ...
      

      As PG_VERSION_NUM is located in the "pg_config.h" file, any TSQLStatement objects can't find this variable now, the above strange message is appeared and further execution is stopped.

       Thank you.

       

      P.S. If the location of "pg_config.h" file can be changed (as in PostgreSQL 10), may be it is more safe to check PostgreSQL (client) version in CMake.

        Attachments

          Activity

            People

            • Assignee:
              amadio Guilherme Amadio
              Reporter:
              kgertsen Konstantin Gertsenberger (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Actual End: