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@mcw.edu
414-955-5654
