Unable to rename table
I'm attempting to rename
ironclad_account_kills to ironclad_account_npc but I'm unable to.
What might be causing this?
error: relation "ironclad_account_npc" does not exist
at /Users/dexter/projects/next/progress.quest/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:43530:21
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async PgPostgres.query (/Users/dexter/projects/next/progress.quest/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:62596:21)
at async pgSuggestions (/Users/dexter/projects/next/progress.quest/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:64890:19)
at async Command.<anonymous> (/Users/dexter/projects/next/progress.quest/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:66233:11) {
length: 119,
severity: 'ERROR',
code: '42P01',
detail: undefined,
hint: undefined,
position: '31',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'parse_relation.c',
line: '1449',
routine: 'parserOpenTable'
}
error: relation "ironclad_account_npc" does not exist
at /Users/dexter/projects/next/progress.quest/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:43530:21
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async PgPostgres.query (/Users/dexter/projects/next/progress.quest/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:62596:21)
at async pgSuggestions (/Users/dexter/projects/next/progress.quest/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:64890:19)
at async Command.<anonymous> (/Users/dexter/projects/next/progress.quest/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:66233:11) {
length: 119,
severity: 'ERROR',
code: '42P01',
detail: undefined,
hint: undefined,
position: '31',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'parse_relation.c',
line: '1449',
routine: 'parserOpenTable'
}
3 Replies
I've went the route of trying to upgrade to 0.23, and now I'm getting an even weirder error
As you can see I'm providing a URL but it's saying I'm not 😅
➜ progress.quest git:(main) ✗ pnpm drizzle-kit push
drizzle-kit: v0.23.0
drizzle-orm: v0.32.0
No config path provided, using default path
Reading config file '/Users/dexter/projects/next/progress.quest/drizzle.config.js'
Error Please provide required params for Postgres driver:
[✓] url: 'postgresql://neondb_owner:
➜ progress.quest git:(main) ✗ pnpm drizzle-kit push
drizzle-kit: v0.23.0
drizzle-orm: v0.32.0
No config path provided, using default path
Reading config file '/Users/dexter/projects/next/progress.quest/drizzle.config.js'
Error Please provide required params for Postgres driver:
[✓] url: 'postgresql://neondb_owner:
import { defineConfig } from "drizzle-kit";
export default defineConfig({
dialect: "postgresql",
schema: "./schema.ts",
out: "./migrations",
dbCredentials: {
url: "postgresql://myuser:mypassword@localhost:5432/mydbname"
}
});
import { defineConfig } from "drizzle-kit";
export default defineConfig({
dialect: "postgresql",
schema: "./schema.ts",
out: "./migrations",
dbCredentials: {
url: "postgresql://myuser:mypassword@localhost:5432/mydbname"
}
});
I’ve already done that, that’s why there’s a tick in the console output