Drizzle Team•2y ago

Schema not ingested with drizzle-orm/node-postgres

I have a db connection for production using Vercel Postgres. It works great. I'm trying to set up a dev connection to a local Postgres instance. I have the following code:

import { drizzle as jsDrizzle } from "drizzle-orm/node-postgres";
const db = jsDrizzle(
      new pkg.Pool({
        connectionString: process.env.LOCAL_POSTGRES_URL,
      }),
      { schema }
    );

import { drizzle as jsDrizzle } from "drizzle-orm/node-postgres";
const db = jsDrizzle(
      new pkg.Pool({
        connectionString: process.env.LOCAL_POSTGRES_URL,
      }),
      { schema }
    );

But, when I run my app, I get Cannot read properties of undefined (reading 'findMany'). This immediately made me think to check that I was passing my schema into drizzle. But, alas, I found that I was already doing that. This is the same schema that I pass into my prod Vercel PG connection, and it works there. Any pointers?

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Schema not ingested with drizzle-orm/node-postgres