crdv7 opened a new issue, #2257:
URL: https://github.com/apache/age/issues/2257
**Describe the bug**
The Makefile fails to install age--1.5.0--1.6.0.sql to the share/extension
directory, postgresql couldn't find the upgrade sql.
**How are you accessing AGE (Command line, driver, etc.)?**
Using psql Command line
**What data setup do we need to do?**
N/A - No specific data setup required, this is a build/installation issue.
**What is the necessary configuration info needed?**
- PostgreSQL 16
- AGE v1.5.0 installed
- AGE v1.6.0 upgrade package prepared
**What is the command that caused the error?**
```pgsql
ALTER EXTENSION age UPDATE TO '1.6.0';
```
```
ERROR: extension "age" has no update path from version "1.5.0" to version
"1.6.0".
```
**Expected behavior**
The ALTER EXTENSION age UPDATE TO '1.6.0' command should successfully
execute the age--1.5.0--1.6.0.sql migration script and upgrade AGE to v1.6.0.
**Environment (please complete the following information):**
- Version: PG16, AGE1.5.0
**Additional context**
Root Cause: The Makefile (line 20) only includes age--1.6.0.sql in the
age_sql variable.
Solution: Add the upgrade script to the Makefile:
Change:
age_sql = age--1.6.0.sql
To:
age_sql = age--1.6.0.sql \
age--1.5.0--1.6.0.sql
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
