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

version 2.0.2 has no update path from version "1.0.7" and could not find function "pg_qualstats_2_0" in file #35

Closed banlex73 closed 3 years ago

banlex73 commented 3 years ago

Hello I have updated binaries to the latest 2.0.2 but couldn't install it on my PG12.5

  1. Update failed alter extension pg_qualstats update; ERROR: extension "pg_qualstats" has no update path from version "1.0.7" to version "2.0.2"
  2. Create from the scratch failed too postgres=# drop extension pg_qualstats; DROP EXTENSION postgres=# create extension pg_qualstats; ERROR: could not find function "pg_qualstats_2_0" in file "/usr/pgsql-10/lib/pg_qualstats.so"
rjuju commented 3 years ago

Hello, Indeed pg_qualstats has no upgrade path, like may other extensions. This isn't required as pg_qualstats doesn't provide any relation that stores data, and not providing an upgrade paths makes the code simpler as it avoids duplicating all the DDL. I have on my todo list to document this point.

rjuju commented 3 years ago

I added the documentation, with some information on the need to restart postgres in https://github.com/powa-team/pg_qualstats/commit/d8a02123f48c83d89a8d05e069f27c79b5ff7729!