Skip to content

Instantly share code, notes, and snippets.

@ORESoftware

ORESoftware/gist:d74b1e6ffd7f02fd658d28c5597a3367

Created March 9, 2025 01:22
Show Gist options
  • Save ORESoftware/d74b1e6ffd7f02fd658d28c5597a3367 to your computer and use it in GitHub Desktop.
Save ORESoftware/d74b1e6ffd7f02fd658d28c5597a3367 to your computer and use it in GitHub Desktop.
Download ZIP
drizzle ORM command results in truncating table
Raw
gistfile1.md

doing migration with Drizzle ORM delete/truncated all data from our "skills" table:

ALTER TABLE "skills" ALTER COLUMN "default_val" SET DEFAULT '{"value":1}';
ALTER TABLE "skills" ALTER COLUMN "skill_desc" SET DATA TYPE jsonb;
ALTER TABLE "skills" ALTER COLUMN "skill_desc" SET DEFAULT '[]'::jsonb;
ALTER TABLE "skills" ALTER COLUMN "skill_desc" SET NOT NULL;
ALTER TABLE "skills" ALTER COLUMN "search_vector" SET DEFAULT ''::tsvector;
ALTER TABLE "skills" ALTER COLUMN "embedding" SET DEFAULT null;

the initial error was that I could not convert skill_desc from text to jsonb automatically

not sure how it could ever result in truncating the whole table regardless....

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment