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.
azure.extensions
-------------------------------
AZURE_AI,AZURE_STORAGE,VECTOR
(1 row)
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