extension "ulid" has no update path from version "0.1.4" to version "0.1.5"

pksunkara / pgx_ulid

Postgres extension for ulid

MIT License

324 stars 21 forks source link

extension "ulid" has no update path from version "0.1.4" to version "0.1.5" #49

Open nbari opened 1 month ago

nbari commented 1 month ago

Any idea about how to upgrade without doing DROP EXTENSION ulid;

cannot drop extension ulid because other objects depend on it
DETAIL:  column id of table tokens depends on type ulid
column id of table metadata depends on type ulid
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

arjunyel commented 1 month ago

ALTER EXTENSION ulid UPDATE TO '0.1.5';

ERROR: extension "ulid" has no update path from version "0.1.3" to version "0.1.5" (SQLSTATE 22023)