[BUG]: node-postgres broken with ESM

[ksmithut]

What version of drizzle-orm are you using?

0.25.1

What version of drizzle-kit are you using?

0.17.5

Describe the Bug

import { drizzle } from 'drizzle-orm/node-postgres'
import pg from 'pg'

const pool = new pg.Pool({
  connectionString: 'postgres://postgres:postgres@127.0.0.1:5432/postgres'
})
const db = drizzle(pool)

The above when run produces the stack trace:

TypeError: Cannot read properties of undefined (reading 'setTypeParser')
    at m.initMappers ([redacted]/node_modules/drizzle-orm/node-postgres/index.mjs:1:2315)

It's attempting to read .setTypeParser from the pg module. I've traced it down to the lines that import * as pg from 'pg. Because pg is commonjs and seems to only do module.exports = from its main module, the imported t looks like { default: mainmodule } instead of mainModule. If you change those to import pg from 'pg' that should fix it, or wherever you reference pg.setTypeParser() and any other pg properties, you just add pg.default.. I'll submit a PR when I get some free time later today.

Expected behavior

No response

Environment & setup

I've run across the same error with node 18.16.0, 19.9.0 and 20.0.0.

[dankochetov]

If your project is ESM, do import * as pg from 'pg'

[dankochetov]

OK, I see what the issue is. Weird, because it worked when I tested with raw Node in ESM mode.

[dankochetov]

The thing is, I don't think we could simply do pg.default, because it won't work in CJS mode.

[ksmithut]

Apologies, I forgot to include the version of pg I was using: 8.10.0. Would you like me to submit a PR? Or do you have an idea of the fix you'd like?

[gijsmin]

Also not working for me. No way to setup Drizzle ORM now.

[Droutin]

Bewest version of drizzle-orm isnt working.. I have to downgrade to ^0.24.2

[dankochetov]

Please check drizzle-orm@beta, should be fixed there
@ksmithut @GM33 @Droutin