Details
-
Sub-task
-
Status: Closed
-
Should
-
Resolution: Fixed
-
None
-
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:
- 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.
- 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.