benjick Comments - Answer Overflow

Topics

benjick

Explore posts from servers

TtRPC DTDrizzle Team

•Created by Cyber Grandma on 9/26/2024 in #help

Possible to have multiple onConflict ?

Too bad! Thanks for letting me know!

6 replies

•Created by Cyber Grandma on 9/26/2024 in #help

Possible to have multiple onConflict ?

Was it?

6 replies

•Created by benjick on 9/24/2024 in #help

drizzle-kit picks wrong version in monorepo (pnpm)

I had to use node-linker=hoisted in .npmrc

5 replies

•Created by benjick on 9/24/2024 in #help

drizzle-kit picks wrong version in monorepo (pnpm)

bump

5 replies

•Created by benjick on 9/24/2024 in #help

drizzle-kit picks wrong version in monorepo (pnpm)

drizzle-kit: v0.22.0
drizzle-orm: v0.29.3

This version of drizzle-kit requires newer version of drizzle-orm

drizzle-kit: v0.22.0
drizzle-orm: v0.29.3

This version of drizzle-kit requires newer version of drizzle-orm

cat package.json | grep drizzle
    "drizzle-kit": "^0.22.0",
    "drizzle-orm": "0.31.4",
    "drizzle-zod": "^0.5.1",

cat package.json | grep drizzle
    "drizzle-kit": "^0.22.0",
    "drizzle-orm": "0.31.4",
    "drizzle-zod": "^0.5.1",

5 replies

•Created by benjick on 7/22/2024 in #help

there is no unique or exclusion constraint matching the ON CONFLICT specification

Big thanks for the help!

48 replies

•Created by benjick on 7/22/2024 in #help

there is no unique or exclusion constraint matching the ON CONFLICT specification

Fixed the data up and generated new migrations

48 replies

•Created by benjick on 7/22/2024 in #help

there is no unique or exclusion constraint matching the ON CONFLICT specification

I had duplicate ids in the table

48 replies

•Created by benjick on 7/22/2024 in #help

there is no unique or exclusion constraint matching the ON CONFLICT specification

Thanks!

48 replies

•Created by benjick on 7/22/2024 in #help

there is no unique or exclusion constraint matching the ON CONFLICT specification

I wonder if it can't apply the constrains

48 replies

•Created by benjick on 7/22/2024 in #help

there is no unique or exclusion constraint matching the ON CONFLICT specification

Yes, it is

48 replies

•Created by benjick on 7/22/2024 in #help

there is no unique or exclusion constraint matching the ON CONFLICT specification

Thanks a lot

48 replies

•Created by benjick on 7/22/2024 in #help

there is no unique or exclusion constraint matching the ON CONFLICT specification

I understand, I will think of something. I do appreciate finding on the reason for this

48 replies

•Created by benjick on 7/22/2024 in #help

there is no unique or exclusion constraint matching the ON CONFLICT specification

Ah okay, maybe a custom one will be fine

48 replies

•Created by benjick on 7/22/2024 in #help

there is no unique or exclusion constraint matching the ON CONFLICT specification

It did not have the index. So should I remove it from the code, generate migrations, add it back?

48 replies

•Created by benjick on 7/22/2024 in #help

there is no unique or exclusion constraint matching the ON CONFLICT specification

I'm gonna create a new local db and run migrations on it and see if it gets the index

48 replies

•Created by benjick on 7/22/2024 in #help

there is no unique or exclusion constraint matching the ON CONFLICT specification

I see, and now I've upgraded and that's why it works locally, because I use db:push

48 replies

•Created by benjick on 7/22/2024 in #help

there is no unique or exclusion constraint matching the ON CONFLICT specification

I think I recently changed to onConflictDoUpdate from DoNothing, that might have exposed this older issue

48 replies

•Created by benjick on 7/22/2024 in #help

there is no unique or exclusion constraint matching the ON CONFLICT specification

But the issue now is really the missing index. Maybe it's been missing a while, since my latest migration doesn't touch it

48 replies

•Created by benjick on 7/22/2024 in #help

there is no unique or exclusion constraint matching the ON CONFLICT specification

I don't think so, I can see the new fields added when I browse the database

48 replies