Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-30389

Handle schema when testing table existence in PostgreSQL

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 10.10
    • Fix Version/s: 11.x
    • Component/s: Core

      Description

      Whereas the test which checks if a table exists takes into account the schema with Oracle, nothing is done with PostgreSQL.

      The request is to add some code to retrieve the current schema set in the DB connection URL and use it in

      metaData.getTables(null, schemaName, ... 

      Configuration to observe the issue:

      nuxeo.db.schema=xxx
      nuxeo.db.jdbc.url=jdbc:postgresql://${nuxeo.db.host}:${nuxeo.db.port}/${nuxeo.db.name}?currentSchema=${nuxeo.db.schema}
      

      and if Nuxeo has already been started in another schema of the same database.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              tmartins Thierry Martins
              Participants:
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: