Uploaded image for project: 'OpenMRS Core'
  1. OpenMRS Core
  2. TRUNK-4881 OpenMRS should support Postgresql
  3. TRUNK-5927

Remove dependency on Liquibase to update PostgreSQL sequences

    XMLWordPrintable

Details

    • Sub-task
    • Status: Closed
    • Should
    • Resolution: Fixed
    • None
    • Core 2.4.0
    • None
    • None
    • Low

    Description

      Currently Liquibase is handling update of PostgreSQL sequences here but we need to remove this dependency and find a programatic way. There are multiple reasons for it:

      1. When we will go for next release, then we will be following the new rules after the liquibase update as mentioned here . Then this change set will become a part of schema. But it is required that these sequences be updated after the core data is inserted. Thus we are bound to face issues on PostgreSQL.
      2. Also in Reference Metadata Module, there are concepts related to covid-19 and many others that are getting inserted in DB. The problem here is for these concepts their id values are specified. So after the insertions the PostgreSQL sequence does not get incremented. Thus here also error arrives when we are inserting concept sources due to inconsistent sequence value.

      Gliffy Diagrams

        Attachments

          Activity

            People

              aman Aman Mishra
              aman Aman Mishra
              Daniel Kayiwa Daniel Kayiwa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: