Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tYpuW-00FkO2-1O for pgsql-general@arkaria.postgresql.org; Fri, 17 Jan 2025 17:13:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tYpuU-002VF7-6B for pgsql-general@arkaria.postgresql.org; Fri, 17 Jan 2025 17:13:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tYpuT-002VEy-8M for pgsql-general@lists.postgresql.org; Fri, 17 Jan 2025 17:13:30 +0000 Received: from mx0b-0021c101.pphosted.com ([205.220.174.137]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tYpuQ-0003Ru-2Q for pgsql-general@lists.postgresql.org; Fri, 17 Jan 2025 17:13:28 +0000 Received: from pps.filterd (m0195928.ppops.net [127.0.0.1]) by mx0a-0021c101.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 50HGpe8P006946 for ; Fri, 17 Jan 2025 11:13:26 -0600 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mcw.edu; h= content-type:date:from:message-id:mime-version:subject:to; s= 11132019PPKEY; bh=Z5mLTi9l5vtv+qwq9jgxFHKBI63XJDe7PypnMmSFgr4=; b= unbG2tef83szb7AEw7yjOplWs94z55b/02zmkCpKnns6k7OFvesvNIz5OwGBz/R7 m30ndpddAiXqdfXXwQLFXyyRtWcP/dg5tkn0vK7HAqNXRDzEntcqEPysG1dD8rdV i4iLVJR2R9Im7Yw5sIsPR6K1acNNPpNYO7UEaB8gXI8QPsc51Q1XoKdjLu7o2Vm4 D0cXKiNbwJ7bXRz5DACuexc8X/Ls+kztadbrG47CXwACYRhSywP1CXQx/hlJW7aJ 3dWYolV8FRfFwHs00AGL+7vEF3HcvncSCFg8DRalczElfh8Jp9E6bswbUY/Ktn3B Y3pdxTgODS39j81qVsptFw== Received: from byapr05cu005.outbound.protection.outlook.com (mail-westusazlp17010005.outbound.protection.outlook.com [40.93.1.5]) by mx0a-0021c101.pphosted.com (PPS) with ESMTPS id 447u3n03f3-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT) for ; Fri, 17 Jan 2025 11:13:26 -0600 (CST) ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=Kut4SA+TbpCPszAQix2beTpOro8an+dl+sxpnMSpNvaBeTqW+99Fl9kfOprPxotjSEUoI86pQna7ITp1X60BHdifNYF4bqchHB5Q6M5q+2Xf03vcFQQ1wTwlB7nGWUuMpInDVNgTHoeCyiRi/qrKcbrNQz8lHM1tBDEGtolXY8CcWM/UNk9H+SErHEZUvULVRvNHtTjUdzgTuykIEHyQ3cLtusupm015+ehUvXz4znwT1OAsdBi1iaoIBsGf+CoDrhhiMjA6IkFa0IISKF+efJtSD7JUfSkdQh8FmyAYtOR4k1FljD01MBLhWqH4ZpzzTwV5ofVsi8WiH6XsPTFIlA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=Z5mLTi9l5vtv+qwq9jgxFHKBI63XJDe7PypnMmSFgr4=; b=zB6UzIhndCmzR8eUnYFXEW5XJSL/im/OZCrgCqyq2TF9O8z9QCauqaBivQmw0GFgC8Po+xHKvtNv4iQFoam7BwV/1aoDb3OmeDtdAPhOHRZakHsS8yNdk8pWpnSjm5PzrZZUx8oe/JfKnRiL4FwAMKcNTGQPsQubt5ANhVSSgY67zb98Pep7IilJWZhxRSE43qIyd70uIWkaBDry30s/GJgBB/0IaJtda9ZO3Oj+xQ69ZuLnfcDflB061r9TKpE12nAboQXqEfdxLegMD+VISTUNgbWMgiSksC/ZU4C2rDc2QR2CiieKyiwIdgOvb0Tm4GIPJIE1tQ0MyUZcC71grQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=mcw.edu; dmarc=pass action=none header.from=mcw.edu; dkim=pass header.d=mcw.edu; arc=none Received: from CH2PR01MB5765.prod.exchangelabs.com (2603:10b6:610:42::30) by PH7PR01MB8643.prod.exchangelabs.com (2603:10b6:510:30c::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8377.7; Fri, 17 Jan 2025 17:13:23 +0000 Received: from CH2PR01MB5765.prod.exchangelabs.com ([fe80::77f2:159b:dfea:4c16]) by CH2PR01MB5765.prod.exchangelabs.com ([fe80::77f2:159b:dfea:4c16%4]) with mapi id 15.20.8377.004; Fri, 17 Jan 2025 17:13:23 +0000 From: "Zacher, Stacy" To: "pgsql-general@lists.postgresql.org" Subject: pgvector extension error Thread-Topic: pgvector extension error Thread-Index: Adto7mcB7/jqRajZQOeUDdyEv7K03A== Date: Fri, 17 Jan 2025 17:13:23 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: CH2PR01MB5765:EE_|PH7PR01MB8643:EE_ x-ms-office365-filtering-correlation-id: d3cdbce9-df5d-473e-834a-08dd371a3fc0 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|41320700013|10070799003|376014|1800799024|38070700018|8096899003; x-microsoft-antispam-message-info: =?us-ascii?Q?zT4+f6ZDhLSzK4r/9OsILy6WkjBZjYzCShgt/CbFQSE7zIBxaVQa4S+hlgGX?= =?us-ascii?Q?lDh+Pno6GK9ofd+xtZf5MpjqsvDaZZh9BQ75tfQse06cPHBMfTwyvTQfvAjr?= =?us-ascii?Q?X2k6Gw+PDeh/HzldhdWYZStNUpdtlj+R7AGWTl305rxjFJFV4GobojT5GOSN?= =?us-ascii?Q?6bmkNod/ifU5A6v6XhVFyCf9QM23/KcE7QvbyVz4R3g7jys8xEV0Z6yCRF7z?= =?us-ascii?Q?gOvtubjQxHrqpvX7AdlPEU/3mrD4sFJXdG+yeqV4MJtIvUq6cy7uULKU6vy7?= =?us-ascii?Q?khbLicU13ppQtvaTEPhFA4LuNUbCm5cUi5rqjymsWiAfbmPacE1O5IvdaqZA?= =?us-ascii?Q?gjYt7nSd3gQFhfU5Hd/EOcXY15+1BOS+jMthqxMzi5WhN2NjaQN1lXSm5zbo?= =?us-ascii?Q?WH0BCD3ir/nEwdqGmN7CtU1BA+odpOZfyQy/GOp6zffp3mzW/E43lq7053tn?= =?us-ascii?Q?5kLLVtEbcnvARvYzLP+OZkLEIPX3/QXf1VF+qOgTsgA6Cy4J4Nnwmm7NV6Nv?= =?us-ascii?Q?+mdgIKokpeL8MbQSf3F4s3tAfvA/q9XGH60wFBwAlpg63ySBCttAz77u9P65?= =?us-ascii?Q?eQLLGuxtUKDMqk9trdwte3C/YFRmDUEe3bKoXM1hV5GI86Zv4jDvIBIHfeVP?= =?us-ascii?Q?5JFqa/B9kbEFd0yzciNCyAIs1cXzEGsVOPkaWBUwUoV+8+2AXbQ8/SioPUPB?= =?us-ascii?Q?5w5af1piK+HRLTrAlga/SR09TBeVhGV/gKpfClr7AIk/RtzqdE0BIV1iYGQ5?= =?us-ascii?Q?VZwrORJqgUZ96snWWRIp6EZfSMrOUorRnqCpHGRPW15wu+FspUj1s//MTfTA?= =?us-ascii?Q?Uvr8GjFGXRuc34RjBaY+BqnWFLvm6J8+SIptnK8g9Pc1GBEL4eR9a0KetJzQ?= =?us-ascii?Q?hd97CXDjcrSu4x86m3THBEVU4xfAnkVkmmOwW7v3LDSZ+hlCFKVaoQqL5Za8?= =?us-ascii?Q?czhT0x9mrq9/ggYDJ6n4tV73gPK+iJdomUnOaDqV7IT+Gvw+KqLKp5r3BTJf?= =?us-ascii?Q?5X53Wk6K6jl2wex4z8CDq3ZFPiXhQzu9PA7HKBGPm1qyBpP7d0utehcaj7SB?= =?us-ascii?Q?TH+BZGXb+mgLBVky3fJF3BfU2unvhLsHL71k/zSoHi8uq8I1qyrdUvXztpIT?= =?us-ascii?Q?H9wm+D4bR8BKW/6DSWDaD1CTeXbU9Cq0puwPEkFz4MOicdTcAExa4urfWSkU?= =?us-ascii?Q?RLCDHfBJeYXjQsYfRMb5NHM6/K0EHd6DJTbQm9Ncjo9c33uq23sHaEU8Vxx/?= =?us-ascii?Q?F1b0eGmwOBO4ZfUnVdQbHc1IBX4yH27OCCEFh9phOWvGj+12CmjfxQKB/9kY?= =?us-ascii?Q?/bVeHPWdDZqnJGHDfJcY+iplsbZR8XWr30U0qMWCvTb+4UZSnxwSQGPDpbpR?= =?us-ascii?Q?6qgO29FxK9vFhOab3/EPQjYp5fAJRsaWbGPrTUAYA9HSls6PSqNmVkkI7TGc?= =?us-ascii?Q?+7VMI6fBX+3AcejXym9USVRg8Z/iQ/Q7?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:CH2PR01MB5765.prod.exchangelabs.com;PTR:;CAT:NONE;SFS:(13230040)(366016)(41320700013)(10070799003)(376014)(1800799024)(38070700018)(8096899003);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?GapMavXF3rUb9hPz/6yhnAG3CoySqZQpR7SrElc/TB7424o3oRSC0vAY/QqS?= =?us-ascii?Q?smse7RGx02Yit30LSPTt4teiM++Id/4eQTUsoJN/V2L5dQMUWTRUGvMP6Fms?= =?us-ascii?Q?VGnHOk3gKibBoWzGNPi8Rg0/Uo+yz/B4I6DM8JOtEZnAnBoi5okZ9tOvo9O7?= =?us-ascii?Q?Ramgu+NgNILH9BYw9hlmX1o09IoSbsyqKfpEmT4NAjlZJ0uT8Iw+h6y4UP1A?= =?us-ascii?Q?xqSXpvvtCQc/SQ4unGn4BzBPJXY9Ok+fDbspRv98B0Bz2OkGSPSXkKZMwmWH?= =?us-ascii?Q?go8drH00FUgihXkhbSAnVWNIgUG9SeMi+qNh/rpodNEfGlUEInaqaWHUGd4w?= =?us-ascii?Q?YAXXdazMILh+N3sO2EFxxe2jee9/t03/IVAbKAnntl2ZK5Zs8ShU5wCk2pft?= =?us-ascii?Q?E/4Ee6cv/tzWkNyPiEHRdO1q/FzRQl2HDq2Ql3TFY/WpQU5YYrpyIdLh6bc3?= =?us-ascii?Q?1eCrbokYEBHu8U0Zha14nNEdovVm+O33jIgID2hSzVg7RmXAPkj+UDxPihne?= =?us-ascii?Q?+8V1VaMPc1qePcsEqTc8d/N8Rompz43mP0AFdHP3ASp5GTJ8X6btC7iSoRoL?= =?us-ascii?Q?q/vdxzVfbgXH4usM6/3+dgu1ItNr8SE4SJAw4DuN8NnoBQ485deMhFVfAOLV?= =?us-ascii?Q?tOfS8x1jwaQtniy7ZvQt6NUmKZk57KEQDJ5+CeKaypl+NlVw6Sfi/QA+aDb3?= =?us-ascii?Q?hru/4FL/Y+zX2ChGeNDTqUM4YhKCFkcTaQY0ix6v5yPghlUFlKafwfp91Gxi?= =?us-ascii?Q?w6tDG8W8yus8svT9xcdYvxYupInOhJqDJsi24gZ/XvDuQA+BFqCBfwjZRLrC?= =?us-ascii?Q?FGmkOUQ+71py6rlsyiBN4ngOyw686a+64F7T+n7Odb9x6G0yYv5Q8mvYlVfV?= =?us-ascii?Q?Rcd6pA4DzelxQAT/3wCOZrmIL/l4+ZE75hkqtGDl//bU/looFrhPK9imr6/Y?= =?us-ascii?Q?ViYA32cx3IctX/D3s87WDOvH3nSOp7+w3tVkOtMxB0c939BXOgKlilCskjN9?= =?us-ascii?Q?zqz/rnYHWLHGfOeNpdso2sQSQb+OgEDXm4jk93iYjb2Z4nOkryyo5kYLGpmV?= =?us-ascii?Q?S6zfwWopgEaqeiLhpL1GiegsWPSZXygls6O48gcq8rtEw41qtM5wsil8YjDz?= =?us-ascii?Q?4GXE4sA0uxryolqCZu3qwVjqUI4n56IXVTfAq72me2CCEGmnlSv0CGhLqvj+?= =?us-ascii?Q?ZmD7NhEq2BdZ5WrmOwg7IAKfsjzC0iGxYZRVfcpnA1EFrhqd5v6YqMTqpPf7?= =?us-ascii?Q?hiN52JMprO3qJBXFNhkQiybDtkCy4DGWckT+jBQ4muRLC9SKk4F0rwEvPq02?= =?us-ascii?Q?mRaj2DNgrvJc5WEjTEzWvwazHGPaovHylfBd+ZM0XfikSeeWonF48nBFIV/j?= =?us-ascii?Q?k9AdC3bpDi6Q8DI6ClG5hgHXTqiGe+Gt3jnfLn61kXGh4HJn0FuMB7g9TUjP?= =?us-ascii?Q?LGc1tWTnvf48wUAALf1CdEbRo+wjSPaUUmQwAqiplmHNa4NfFRmv/HC7OdcZ?= =?us-ascii?Q?jh9UAN+BsyC2TKQgM+26RfjLl/xFALcstrhxS7jVOd7qA7edF5/7lOJxMQlt?= =?us-ascii?Q?0hYlovHElSjwpw4SI1xyBr9QOByu4r0aH7/xlHFFZgMV7i0IIhCZGxlOQwKZ?= =?us-ascii?Q?AzXtJSwDlECKqtHkmW3hMzs=3D?= Content-Type: multipart/alternative; boundary="_000_CH2PR01MB5765698BB9F71CEB662D5AE4AD1B2CH2PR01MB5765prod_" MIME-Version: 1.0 X-OriginatorOrg: mcw.edu X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: CH2PR01MB5765.prod.exchangelabs.com X-MS-Exchange-CrossTenant-Network-Message-Id: d3cdbce9-df5d-473e-834a-08dd371a3fc0 X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Jan 2025 17:13:23.4495 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 9963652a-ab0a-4f1b-994a-b49e83d90f0e X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: dAoEzXIjQtZBztmdKS62U913StdmIV2RcTHP23W7I0XuvKmJTuNhoGTCuAwtoYRh X-MS-Exchange-Transport-CrossTenantHeadersStamped: PH7PR01MB8643 X-Proofpoint-GUID: Tu9VmLQCwH0vabNaDEY0JnWTvOseMuOp X-Proofpoint-ORIG-GUID: Tu9VmLQCwH0vabNaDEY0JnWTvOseMuOp X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1057,Hydra:6.0.680,FMLib:17.12.68.34 definitions=2025-01-17_06,2025-01-16_01,2024-11-22_01 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 clxscore=1015 impostorscore=0 phishscore=0 spamscore=0 lowpriorityscore=0 priorityscore=1501 malwarescore=0 mlxlogscore=692 suspectscore=0 mlxscore=0 adultscore=0 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.19.0-2411120000 definitions=main-2501170135 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_CH2PR01MB5765698BB9F71CEB662D5AE4AD1B2CH2PR01MB5765prod_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 i= t's not there: postgres=3D# \c dbdev You are now connected to database "dbdev" as user "postgres". dbdev=3D# select * from pg_extension; oid | extname | extowner | extnamespace | extrelocatable | extversion | = extconfig | extcondition -------+---------+----------+--------------+----------------+------------+-= ----------+-------------- 13422 | plpgsql | 10 | 11 | f | 1.0 | = | (1 row) dbdev=3D# create extension if not exists vector; ERROR: type "vector" already exists dbdev=3D# drop extension pgvector; ERROR: extension "pgvector" does not exist Works in a different database on the same server: dbdev=3D# \c dbrag; You are now connected to database "dbrag" as user "postgres". It works in this database below. dbrag=3D# 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 i= t. Thank you, Stacy Zacher Enterprise Database Administrator III | Information Services Medical College of Wisconsin szacher@mcw.edu 414-955-5654 --_000_CH2PR01MB5765698BB9F71CEB662D5AE4AD1B2CH2PR01MB5765prod_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 i= t’s not there:

 

postgres=3D# \c dbdev

You are now connected to database "dbdev" = as user "postgres".

dbdev=3D# select * from pg_extension;

  oid  | extname | extowner | extnamespace= | extrelocatable | extversion | extconfig | extcondition

-------+---------+----------+--------------+--------= --------+------------+-----------+--------------

13422 | plpgsql |      = ; 10 |           11 | f&n= bsp;            = ; | 1.0        |    =        |

(1 row)

 

dbdev=3D# create extension if not exists vector;

ERROR:  type "vector" already exists<= o:p>

dbdev=3D# drop extension pgvector;

ERROR:  extension "pgvector" does not= exist

 

Works in a different database on the same server:

 

dbdev=3D# \c dbrag;

You are now connected to database "dbrag" = as user "postgres".

It works in this database below.  

dbrag=3D# select * from pg_extension;

  oid   | extname | extowner | extnam= espace | extrelocatable | extversion | extconfig | extcondition<= /p>

--------+---------+----------+--------------+-------= ---------+------------+-----------+--------------

  13422 | plpgsql |    &nbs= p;  10 |           1= 1 | f           &nbs= p;  | 1.0        |   = ;        |

157739 | vector  |     = ;  10 |         2200 | t =              | = 0.7.4      |      &n= bsp;    |

(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<= /span>

szacher@mcw.edu

414-955-5654

 =

 =

 

--_000_CH2PR01MB5765698BB9F71CEB662D5AE4AD1B2CH2PR01MB5765prod_--