Azure / azure-postgresql

Azure Database for PostgreSQL (fully managed service for PostgreSQL in Azure)
MIT License
77 stars 78 forks source link

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

Open SeaDude opened 9 months ago

SeaDude commented 9 months ago

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? 
SeaDude commented 8 months ago

Bump