piton Posts - Answer Overflow

piton

Explore posts from servers

MIA🎄 Moonlink.js - Imagine a Music Application DTDrizzle Team

•Created by piton on 4/3/2024 in #help

Empty default array

Im creating text array with empty array as default like this tags: text("tags").array().default([]), but when i do drizzlekit push:pg it gives the following changes but when applying the changes it errors out:

ALTER TABLE "users" ALTER COLUMN "favorites" SET DEFAULT ;
ALTER TABLE "files" ALTER COLUMN "tags" SET DATA TYPE text[];
ALTER TABLE "files" ALTER COLUMN "tags" SET DEFAULT ;

ALTER TABLE "users" ALTER COLUMN "favorites" SET DEFAULT ;
ALTER TABLE "files" ALTER COLUMN "tags" SET DATA TYPE text[];
ALTER TABLE "files" ALTER COLUMN "tags" SET DEFAULT ;

Error: error: syntax error at or near ";" position: 58 (which means at the end of the first query)

4 replies

DTDrizzle Team

•Created by piton on 4/1/2024 in #help

Self-Relation in Drizzle ORM?

5 replies

Gaming

Programming