Hey, I have an existing table in my neon database but when i run the command "npx drizzle-kit push"
Im getting this error
'@Neondatabase/serverless' can only connect to remote Neon/Vercel Postgres/Supabase instances through a websocket
[✓] Pulling schema from database...
error: cannot drop sequence "mockInterview_id_seq" because other objects depend on it
at /Users/raunak07/Documents/Code/interview/node_modules/drizzle-kit/bin.cjs:96850:23
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Object.query (/Users/raunak07/Documents/Code/interview/node_modules/drizzle-kit/bin.cjs:121510:26)
at async pgPush (/Users/raunak07/Documents/Code/interview/node_modules/drizzle-kit/bin.cjs:124361:13)
at async _Command.<anonymous> (/Users/raunak07/Documents/Code/interview/node_modules/drizzle-kit/bin.cjs:131618:7) {
length: 304,
severity: 'ERROR',
code: '2BP01',
detail: 'default value for column id of table "mockInterview" depends on sequence "mockInterview_id_seq"',
hint: 'Use DROP ... CASCADE to drop the dependent objects too.',
position: undefined,
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'dependency.c',
line: '1204',
routine: 'reportDependentObjects'
}
Im attaching errors and my code snapshots
Any help is appreciated, Thank you
0 Replies