DT
Drizzle Team•13mo ago
Noahh

drizzle-kit generate:pg throws ERR_INVALID_RETURN_PROPERTY_VALUE

I have my drizzle.config.ts file unchanged (besides adding driver) from before the recent update (see below), but after updating to latest I am getting an error: TypeError [ERR_INVALID_RETURN_PROPERTY_VALUE]: Expected a url string to be returned for the "url" from the "drizzle-kit/loader.mjs 'resolve'" function but got instance of String. 
import { Config } from 'drizzle-kit';

export default {
  schema: './src/db/schema/*',
  out: './migrations',
  driver: 'pg',
} satisfies Config;
import { Config } from 'drizzle-kit';

export default {
  schema: './src/db/schema/*',
  out: './migrations',
  driver: 'pg',
} satisfies Config;
drizzle-kit: v0.19.1
drizzle-orm: v0.27.0
drizzle-kit: v0.19.1
drizzle-orm: v0.27.0
8 Replies
Noahh
Noahh•13mo ago
Reverted to the previous versions of all drizzle packages with the same config (without driver) and it worked fine, let me know if you ned any of my schema or migration info.
Andrii Sherman
Andrii Sherman•13mo ago
Known issue
Andrii Sherman
Andrii Sherman•13mo ago
https://github.com/drizzle-team/drizzle-orm/issues/781
GitHub
[BUG]:Drizzle-Kit 0.19.0 Fails to Generate Migrations · Issue #781 ...
What version of drizzle-orm are you using? 0.27.0 What version of drizzle-kit are you using? 0.19.0 Describe the Bug I was using Drizzle Kit version of 0.18.1 and generating migrations with this co...
Andrii Sherman
Andrii Sherman•13mo ago
Does that happen on Windows?
uhkriss
uhkriss•13mo ago
Happens to me on Windows 11
Andrii Sherman
Andrii Sherman•13mo ago
Yeah, then it’s 100% Windows only We are working on a fix Will ping you here
Md Jahidul Islam milon
Md Jahidul Islam milon•13mo ago
same issue on windows 10
leonss23
leonss23•13mo ago
same issue, windows 10, try Linux/WSL
Want results from more Discord servers?
Add your server
More Posts
How to do migrations that require data changes?Hi, how can I migrate a live database that requires to do a more complicated data shuffling, e.g. I Typescript Problem, do you have an idea ?Property 'user' does not exist on type 'DrizzleTypeError<"Seems like the schema generic is missing -How do I use "the connection pooler"?On the docs for Supabase, it says "Connect to your database using the Connection Pooler for serverledynamic relational queries column returnsHi I'm not entirely sure if this is the intended result when trying to make a relational query. ```Error updating a recordI'm getting an error `typescript: Cannot find name 'buildings'. Did you mean 'buildingId'? [2552]` wusing postgres-js for connectionI am trying to setup drizzle with postgres-js package ( as document it be fastest). Referring to thiHow to check if is not nullHello, ```await db.query.users.findFirst({where: (users, { eq }) => eq(users.name, 'test')});``` i Using PgArrayHello, How can I use postgres arrays in drizzle? I want to have one column to be a string array. ThTimestamp as stringso when i have a timestamp in string mode, setting `new Date().toISOString()` does not work - i needdb push when adding notNull column with default() valueI've added this column to my table: `fullfilled: boolean("fullfilled").default(false).notNull(),` B