m83
DTDrizzle Team
•Created by Chaaaaaaase on 5/28/2024 in #help
Permission denied during 'migrate' command under locked-down database
@Raphaël M (@rphlmr) ⚡ any timeline when this RFC is planned to see daylight? This is the only blocker for me to have drizzle running e2e from standard dx of creating/updating schemas locally to running migrations in the cloud k8s environments. I'd patch the migrator in my
node_modules, but this is very flaky solution that I'd like to drop5 replies
DTDrizzle Team
•Created by Chaaaaaaase on 5/28/2024 in #help
Permission denied during 'migrate' command under locked-down database
I ran into the same issue with one of the cloud providers. Config is the same as yours, using
public schema for migrations as I've only got access to it. The problem is that drizzle tries to run CREATE SCHEMA IF NOT EXISTS public which triggers permission denied (it can't create schemas, and in this case it shouldn't try as public is default one). Not sure yet what the solution is, but I think I'll drop drizzle for migrations (orm is still awesome!) - it generates too loose code to my liking, like migrations shouldn't have "if not exists" clauses..5 replies