drizzle-team / drizzle-team/drizzle-orm

[BUG]: `drizzle-kit generate` didn't add `CREATE EXTENSION IF NOT EXISTS vector;`

Open
#3,929 6 comments 1 reaction 0 assignees View on GitHub
db/postgres drizzle/kit improvement
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Report hasn't been filed before.

- [X] I have verified that the bug I'm about to report hasn't been filed before.

### What version of `drizzle-orm` are you using?

0.38.3

### What version of `drizzle-kit` are you using?

0.30.1

### Other packages

_No response_

### Describe the Bug

my scheme.ts

```
import { index, integer, pgTable, varchar, text, timestamp, vector, json } from "drizzle-orm/pg-core";
import { EMBEDDING_DIMENSIONS } from "../embedding/consts";

export const myEmbeddingTable = pgTable(
"my_embedding",
{
id: integer().primaryKey().generatedAlwaysAsIdentity(),
name: varchar({ length: 255 }).notNull(),
content: text("content").notNull(),
metadata: json("metadata"),
embedding: vector("embedding", {
dimensions: EMBEDDING_DIMENSIONS
}),
created_at: timestamp("created_at").notNull().defaultNow(),
updated_at: timestamp("updated_at").notNull().defaultNow(),
},
(table) => [
index("embedding_index").using("hnsw", table.embedding.op("vector_cosine_ops"))
]
);
```

then I run `drizzle generate`, it created a `.sql` file but it's missing

```
CREATE EXTENSION IF NOT EXISTS vector;
```

at the first line which will cause error if I run `drizzle migrate`:

```
[⣷] applying migrations...error: type "vector" does not exist
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.