public inbox for [email protected]  

help / color / mirror / Atom feed

From: Zacher, Stacy <[email protected]>
To: [email protected] <[email protected]>
Subject: pgvector extension error
Date: Fri, 17 Jan 2025 17:13:23 +0000
Message-ID: <CH2PR01MB5765698BB9F71CEB662D5AE4AD1B2@CH2PR01MB5765.prod.exchangelabs.com> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: pgvector extension error
  In-Reply-To: <CH2PR01MB5765698BB9F71CEB662D5AE4AD1B2@CH2PR01MB5765.prod.exchangelabs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox