|
Hello: We are having issues getting the pgvector extension to work in a database.
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
414-955-5654 |
