Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Postgresql database upgrade scripts for 1.15.0 err with syntax errors #131

Open
bmcann opened this issue Sep 9, 2021 · 1 comment
Open

Postgresql database upgrade scripts for 1.15.0 err with syntax errors #131

bmcann opened this issue Sep 9, 2021 · 1 comment
Assignees
@joaocosta

Comments

@bmcann
Copy link

bmcann commented Sep 9, 2021

The application of upgrade/1.15.0/30_hostlinks_parents.psql in the event of a database upgrade to aquilon 1.15.0 and the application of upgrade/1.15.0/70_hostlinks_parents.psql.backout in the event of a database downgrade from aquilon 1.15.0 both fail due to incorrect postgresql syntax.

I will submit a PR with the corrected syntax shortly.
bmcann pushed a commit to bmcann/aquilon that referenced this issue Sep 9, 2021
Correct postgresql syntax errors in database upgrade to 1.15.0:
c2f79b3 
- Correct the syntax errors that occur when removing (upgrade) or
  restoring (backout) the "NOT NULL" constraint on the "target" column
  in the "hostlink" table.
- This commit addresses issue quattor#131

Change-Id: I86c5a8d4d09c5becfc545b2dcb557e831d30c275
@bmcann bmcann mentioned this issue Sep 9, 2021
Open
@bmcann
Copy link
Author

bmcann commented Sep 9, 2021

Pull request #132 submitted with psql code corrections.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@joaocosta joaocosta

Labels
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@joaocosta @bmcann