search

powa-team / pg_qualstats

A PostgreSQL extension for collecting statistics about predicates, helping find what indices are missing
Other
272 stars 26 forks source link

[Doc] ALTER EXTENSION UPDATE fails #34

Closed Krysztophe closed 2 years ago

Krysztophe commented 3 years ago

There is no SQL scripts, so ALTER EXTENSION UPDATE fails:

powa=# ALTER EXTENSION pg_qualstats UPDATE;
ERROR: extension "pg_qualstats" has no update path from version "2.0.1" to version "2.0.2"

As in https://github.com/HypoPG/hypopg/issues/54, I suppose that it just needs a line about the upgrade in the documentation.

rjuju commented 3 years ago

Done in https://github.com/powa-team/pg_qualstats/commit/d8a02123f48c83d89a8d05e069f27c79b5ff7729!

Krysztophe commented 3 years ago

Thanks!

rjuju commented 3 years ago

As mentioned in https://github.com/HypoPG/hypopg/issues/54 I'm now willing to reconsider this.

I'm keeping this issue opened as a reminder.

rjuju commented 2 years ago

I bumped current HEAD to version 2.0.4 and provided an (empty for now) upgrade script. Version 2.0.4 and later will therefore have an upgrade script. so I'm closing this issue!