Rename conflicted column (postgres)
I am having a bit of trouble getting this to work.
Error I get
await db
.insert(schema.listings)
.values(listings)
.onConflictDoUpdate({
target: schema.listings.SKU,
set: {
SKU: sql`CONCAT(EXCLUDED.${schema.listings.SKU.name}, '-duplicate')`,
},
});await db
.insert(schema.listings)
.values(listings)
.onConflictDoUpdate({
target: schema.listings.SKU,
set: {
SKU: sql`CONCAT(EXCLUDED.${schema.listings.SKU.name}, '-duplicate')`,
},
});Error I get
Uncaught (in promise) PostgresError: syntax error at or near "$601" Uncaught (in promise) PostgresError: syntax error at or near "$601"The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources
Similar Threads
Was this page helpful?
