3 replies

Empty default array

Im creating text array with empty array as default like this

tags: text("tags").array().default([]),

tags: text("tags").array().default([]),

but when i do

drizzlekit push:pg

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 ";"

error: syntax error at or near ";"

position: 58

position: 58

(which means at the end of the first query)

Drizzle Team•2y ago•

3 replies

piton

Empty default array

Im creating text array with empty array as default like this

tags: text("tags").array().default([]),

tags: text("tags").array().default([]),

but when i do

drizzlekit push:pg

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 ";"

error: syntax error at or near ";"

position: 58

position: 58

(which means at the end of the first query)

Empty default array

Similar Threads

Empty default array

Similar Threads

Similar Threads

Similar Threads