"Index Suggestions" errors when hypopg is not installed

[pgiraud]

In the query overview, if hypopg is not installed for the given database, the "Index Suggestions" in "Predicates" tab loads indefinitely . The corresponding XHR request actually returns a 500 error:

/server/1/metrics/database/obvious/query/9191891907659356179/indexes/?from=2024-12-20%2008%3A28%3A07%2B0100&to=2024-12-20%2009%3A28%3A07%2B0100

Traceback (most recent call last):
  File "/usr/local/lib/python3.9/dist-packages/tornado/web.py", line 1711, in _execute
    result = method(*self.path_args, **self.path_kwargs)
  File "/usr/local/src/powa-web-dev/powa/query.py", line 583, in get
    ind.name = self.execute(
  File "/usr/local/src/powa-web-dev/powa/framework.py", line 653, in execute
    raise e
  File "/usr/local/src/powa-web-dev/powa/framework.py", line 641, in execute
    cur.execute(query, params)
  File "/usr/local/src/powa-web-dev/powa/framework.py", line 64, in execute
    query = resolve_nsps(query, self.connection)
  File "/usr/local/src/powa-web-dev/powa/framework.py", line 91, in resolve_nsps
    return query.format(**connection._nsps)
KeyError: 'hypopg'

Actually the flash message cannot be displayed since it's a KeyError not a psycopg2.Error.

Steps to reproduce:

• run the powa-dev-demo.yml podman compose file,
• drop the extension in obvious database:
  • podman exec -it powa-dev-remote-primary bash)
  • su postgres,
  • psql -d obvious
  • DROP extension hypopg;