node-postgres

node-postgres copied to clipboard

Inserting Bulk Data unsing pg

2

I am using pg.pool to connect and do operations on the database. But is there any way to insert bulk data while using pg? I can insert it while using...

arater

Allow users to pass certs when PG environment variable PGSSLMODE=require/verify-ca/verify-full

4

Previously if `readSSLConfigFromEnvironment` was used to generate the SSL config, the ssl object would not be created to create certs. I ran into this issue when trying to execute yarn...

RichardJCai

fix(pg-connection-string): get closer to libpq semantics for `sslmode`

10

## Summary We have found that the handling of the `sslmode` connection string parameter is inconsistent with other PG libraries and with the reference [libpq documentation](https://www.postgresql.org/docs/12/libpq-connect.html#LIBPQ-CONNSTRING). This PR proposes some...

pmalouin

when using babel, pg-native is always required (and fails if not present)

36

I'm not sure if this is a Babel or a node-postgres bug, steps to reproduce: ``` export PATH=$PATH:/tmp/iojs-v3.0.0-linux-x64/bin/:./node_modules/.bin mkdir t cd t npm install babel pg # create a t.js...

nahuel

Curious behavior: `idleTimeoutMillis` works locally, but not on "serverless" environments

26

I was skeptical to write this issue since it might involve other things, not just `pg`, but I will give it a try: So, everything works as expected on `localhost`:...

filipedeschamps

Add a specific error class and error codes

1

Errors that come from postgres queries are wrapped in `pg.DatabaseError`, so we can do `instanceof` checks. And they have the standard postgres metadata like `code` that comes from the postgres...

rightaway

Fallback to non-SSL connection

4

The default `sslmode` in libpq is `prefer`: > first try an SSL connection; if that fails, try a non-SSL connection It should be possible to have similar fallback behavior in...

gabegorelick

``` const client = new pg.Client() await client.connect() await client.end() // ok await client.end() // uh-oh! This never resolves! ``` Ideally we should just not try to end the client...

cody-greene

Updating to the newest version of pg-types

10

Currently, the [pg](https://www.npmjs.com/package/pg) library uses a very old version of [pg-types](https://www.npmjs.com/package/pg-types). Is there something, in particular, that is stopping us from updating to the newest version of the pg-types library?

mwanago

Strange results with connection pool and max connections

4

The setup setting the `max` options to 50 connection I am doing a Promise.all() on 20 items which all call the below code where db is the pool. This should...

nmaves