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
[email protected]<mailto:[email protected]>
414-955-5654
