Azure / Azure/azure-postgresql

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

Open
#115 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
Bicep
Stars
87
Forks
81
PR merge metrics
No merged PRs in 30d

Description

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](https://github.com/Azure/azure-postgresql/assets/8636973/e5f4b285-50c3-4c6e-903a-d7d1da83f09c)

**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](https://github.com/Azure/azure-postgresql/issues/113) 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?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.