Still an issue: ERROR: must be owner of extension vector

Product Support
3

Thanks @Falco that solved the issue for me!

Since Azure doesn’t allow specifying the version I ran ALTER EXTENSION vector UPDATE to update to the latest available version. The extension installs are specific to the database, so need to connect to the discourse database (not the default postgres db) to run the update statement.

Here’s how to check the current installed version and to update.

The image shows a SQL query executed in a PostgreSQL environment, updating the version of the 'vector' extension, and the updated version is displayed after the query is executed. (Captioned by AI)
The image shows a SQL query executed in a PostgreSQL environment, updating the version of the 'vector' extension, and the updated version is displayed after the query is executed. (Captioned by AI)2506×694 34.6 KB

SELECT name, default_version, installed_version FROM pg_available_extensions WHERE name = 'vector';