drizzle-team / drizzle-team/drizzle-orm
[BUG]: `drizzle-kit generate` didn't add `CREATE EXTENSION IF NOT EXISTS vector;`
- 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
Assessment
This issue has not been assessed yet.