Azure/azure-postgresql

Type vector does not exist, even though "VECTOR" extension is installed

Opened this issue · 1 comments

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.

image

Steps to reproduce:

  1. Fresh install in a new Resource Group
  2. Create a new database
  3. Install AZURE_AI, AZURE_STORAGE and VECTOR extensions and Save
  4. Click Connect next to the new database
  5. Create a new Azure Cloud Shell Storage Account
  6. Fix the Incorrectly escaped characters in the default Cloud Shell command
  7. 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:

  1. Uninstalled/reinstalled extensions
  2. Uninstalled/reinstalled extensions one-at-a-time
  3. 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?

Bump