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

414-955-5654