dbdev icon indicating copy to clipboard operation
dbdev copied to clipboard

Installing a new pg_tle extension version which requires following an upgrade path doesnt' work

Open tiniscule opened this issue 1 year ago • 5 comments

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

tiniscule avatar Jan 02 '24 02:01 tiniscule