Actions
Defect #2811
closed
Some flyway scripts depend on a "public" schema (Postgresql).
Start date:
05/13/2021
Due date:
% Done:
100%
Estimated time:
Affected versions:
Owner:
Related issues
Updated by Radek Tomiška over 3 years ago
- Related to Defect #2477: Application won't start with existing data under MSSQL database added
Updated by Vít Švanda over 3 years ago
- Subject changed from Some flyway scirpts depend on a "public" schema. to Some flyway scirpts depend on a "public" schema (Postgresql).
- Status changed from In Progress to Needs feedback
- Assignee changed from Vít Švanda to Radek Tomiška
- % Done changed from 0 to 90
Fixed.
The public schema was used in two scripts "V10_04_004__delegations.sql" and "V8_02_003__role-guarantee-by-role.sql". Two more scripts were depended on "V8_02_003__role-guarantee-by-role.sql", so that four scripts were removed/moved and modified (IF NOT EXIST). The IF NOT EXIST clause for all use cases should be supported by Postgresql 9.5 and higher.
Commit: https://github.com/bcvsolutions/CzechIdMng/commit/1a8605deee5c61ed4593e443053c6f3a016b21a7
Updated by Radek Tomiška over 3 years ago
- Subject changed from Some flyway scirpts depend on a "public" schema (Postgresql). to Some flyway scripts depend on a "public" schema (Postgresql).
- Status changed from Needs feedback to Closed
- Assignee changed from Radek Tomiška to Vít Švanda
- % Done changed from 90 to 100
I did test and code review, it works, thx for fix!
Actions