Azure / Azure/azure-postgresql
Type vector does not exist, even though "VECTOR" extension is installed
- 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.

**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.