Overcoming issue with `withSchema` and `forUpdate`

Hi chaps, I just posted a github issue: https://github.com/kysely-org/kysely/issues/1324 w.r.t. Kysely using qualified table names in the forUpdate if withSchema is used. Postgres doesn't like this and will error - I wonder if there is anything I can do short-term/now to skirt this issue that doesn't cause the typechecker to complain? Thanks!
GitHub
[BUG] "FOR UPDATE must specify unqualified relation names" with `.f...
forUpdate with specified table names causes a PG error if the query uses an explicit withSchema with error: FOR UPDATE must specify unqualified relation names Repro: import { CamelCasePlugin, Kysel...
Solution:
For now, you can install a plugin like this to your Kysely instance. Unfortunately there's no other workaround before we fix the bug https://kyse.link/mj9c1
Jump to solution
2 Replies
Solution
koskimas
koskimas4mo ago
For now, you can install a plugin like this to your Kysely instance. Unfortunately there's no other workaround before we fix the bug https://kyse.link/mj9c1
Tim Lonsdale
Tim LonsdaleOP4mo ago
Thanks for this @koskimas!

Did you find this page helpful?