Type vector does not exist, even though "VECTOR" extension is installed
Opened this issue · 1 comments
SeaDude commented
Hello,
Something definitely changed since yesterday. For the past few days I've been putting together an article and video showcasing Azure Database for PostgreSQL. I've taken many screenshots and walked through deployments 3-4x. Today, installing the VECTOR
extension no long works.
Steps to reproduce:
- Fresh install in a new Resource Group
- Create a new database
- Install
AZURE_AI
,AZURE_STORAGE
andVECTOR
extensions andSave
- Click
Connect
next to the new database - Create a new Azure Cloud Shell Storage Account
- Fix the Incorrectly escaped characters in the default Cloud Shell command
- Try to create a new table that has a vector column
CREATE TABLE tbltest ( id bigserial primary key, text_content text, vector_content vector(3) );
- Receive the error:
ERROR: type "vector" does not exist LINE 4: vector_content vector(3)
- This worked fine on previous days!
Running SHOW azure.extensions;
yields:
azure.extensions
-------------------------------
AZURE_AI,AZURE_STORAGE,VECTOR
(1 row)
Troubleshooting tried:
- Uninstalled/reinstalled extensions
- Uninstalled/reinstalled extensions one-at-a-time
- Ran the following:
testdb=> SHOW azure.extensions;
azure.extensions
-------------------------------
AZURE_AI,AZURE_STORAGE,VECTOR
(1 row)
testdb=> SELECT oid, extname, extversion FROM pg_extension;
oid | extname | extversion
-------+---------+------------
14126 | plpgsql | 1.0
(1 row)
testdb=> CREATE TABLE tbltest (
id bigserial primary key,
text_content text,
vector_content vector(3)
);
ERROR: type "vector" does not exist
LINE 4: vector_content vector(3)
^
testdb=> CREATE EXTENSION vector;
CREATE EXTENSION
testdb=> SELECT oid, extname, extversion FROM pg_extension;
oid | extname | extversion
-------+---------+------------
14126 | plpgsql | 1.0
25107 | vector | 0.5.1
(2 rows)
testdb=> CREATE TABLE tbltest (
id bigserial primary key,
text_content text,
vector_content vector(3)
);
CREATE TABLE
Seems that the azure.extensions
VECTOR
isn't working, at least not for me.
Thoughts?
SeaDude commented
Bump