dbdev
dbdev copied to clipboard
Installing a new pg_tle extension version which requires following an upgrade path doesnt' work
Bug report
I have 2 files for my extension.
basejump_core--2.0.1.sql basejump_core--2.0.1--2.1.0.sql
Default version set to 2.1.0.
On a clean install, running create extension "basejump_core" version '2.1.0';
will fail with the following error:
ERROR: could not find sql function "basejump_core--2.1.0.sql" for extension basejump_core in schema pgtle
Based on the pg_tle docs, this appears like it should work by first installing 2.0.1 and then following the 2.1.0 path - but doesn't seem to.
To Reproduce
Here's a PR with the upgrade I'm working on which doesn't work: https://github.com/usebasejump/basejump/pull/57
Expected behavior
I expect the extension to be installable to 2.1.0 without having a dedicated basejump_core--2.1.0.sql
extension file