pgvector extension error

Hello:

We are having issues getting the pgvector extension to work in a database.

* Installed the code
* Created the extension in a database - it says it already exists but it's not there:

postgres=# \c dbdev
You are now connected to database "dbdev" as user "postgres".
dbdev=# select * from pg_extension;
oid | extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
-------+---------+----------+--------------+----------------+------------+-----------+--------------
13422 | plpgsql | 10 | 11 | f | 1.0 | |
(1 row)

dbdev=# create extension if not exists vector;
ERROR: type "vector" already exists
dbdev=# drop extension pgvector;
ERROR: extension "pgvector" does not exist

Works in a different database on the same server:

dbdev=# \c dbrag;
You are now connected to database "dbrag" as user "postgres".
It works in this database below.
dbrag=# select * from pg_extension;
oid | extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
--------+---------+----------+--------------+----------------+------------+-----------+--------------
13422 | plpgsql | 10 | 11 | f | 1.0 | |
157739 | vector | 10 | 2200 | t | 0.7.4 | |
(2 rows)

Question: how can I fix the error in the dbdev database?

We already did a reinstall of the extension code and that didn't resolve it.

Thank you,

Stacy Zacher
Enterprise Database Administrator III | Information Services
Medical College of Wisconsin
szacher(at)mcw(dot)edu<mailto:szacher(at)mcw(dot)edu>
414-955-5654