node-postgres
node-postgres copied to clipboard
brianc
PostgreSQL client for node.js.
Im trying to connecto to remote database. I can connect using psql client. But i get "Connection terminated unexpectedly" error while trying to run this (with same connection string as...
Does `connectionTimeoutMillis` have any effect on queued queries? i.e., if a query sitting in the pending queue > `connectionTimeoutMillis`, does it get removed completely?
libpq shipped with Postgres 14 now allows using pipelining mode https://www.postgresql.org/docs/14/libpq-pipeline-mode.html as stated by these docs > While the pipeline API was introduced in PostgreSQL 14, it is a client-side...
Is there an official way to release prepared statements that use the `pgClient.query({name: "...", ...})` interface? I have a solution, but I'm a bit worried it could break in a...
var query = { text: 'SELECT * FROM advertisement WHERE (brand_class = ($1) AND product_class = ($2)) ', values: [brand_class,product_class] }; const client = await pool.connect(); const res = await...
So in my app I have postgres pool active. Now if I try to instantiate a pg.Client with the same connection info as that of the pg.Pool and then call...
From the docs it looks like prepared statements can only be created and then immediately executed. I want to create a prepared statement without executing it, and I also need...
Hello, Regularly there some questions about how to make batch inserts/updates and how to escape values safely. Eg see : #1400 https://github.com/brianc/node-postgres/issues/1387 #957 https://github.com/brianc/node-postgres/issues/880 I don't find any reference to...
Hi. We have updated our set up from nodejs 12.16.1 psql (PostgreSQL) 10.1 pg 7.11.0 to: nodejs 14.18.1 psql (PostgreSQL) 10.1 (also on 13.1) pg 8.7.1 After that, when any...
Since upgrading from pg 7.4.1 to pg 7.7.1, we are getting "Client has encountered a connection error and is not queryable" error in production after a week of working just...
