capaj Posts - Answer Overflow

capaj

Explore posts from servers

•Created by capaj on 11/24/2023 in #help

Error this query cannot be compiled to SQL

I am trying to do

          await trx.executeQuery(
            sql<any>`ALTER SCHEMA ${current.subdomain} RENAME TO ${subdomain};`
          )
        }

          await trx.executeQuery(
            sql<any>`ALTER SCHEMA ${current.subdomain} RENAME TO ${subdomain};`
          )
        }

anybody have an idea how to do this query?

13 replies

KKysely

•Created by capaj on 11/21/2023 in #help

getting Error: relation "myschema.kysely_migration_lock" does not exist

Hey, I am trying to use the migrator.migrateToLatest() to migrate a DB for me and it is failing with Error: relation "myschema.kysely_migration_lock" does not exist. Do I have to create the kysely tables manually to be able to run the migrator? I would have expected that the migrator creates these tables when they do not exist.

3 replies

Gaming

Programming