node-postgres
node-postgres copied to clipboard
brianc
PostgreSQL client for node.js.
When `import`ing a CommonJS library, it's flattened into a single object, and you're unable to take advantage of any ESM features. However if you add a few lines to your...
Hi, I'm facing to a pretty annoying issue. Here my connection code: ``` class Database { public client: Pool = new Pool(); public async connect() { console.log('INIT DATABASE CONNECTION') this.client...
Fail to update multiple rows in node-pg with prepared statement ``` CREATE TABLE user( id serial primary key, point INT ) INSERT INTO user(point) VALUES (11),(22),(33); const { Pool, Client...
So in PostgreSQL one can do something like: ```sql SELECT _id, body, (SELECT posts FROM posts WHERE posts._id=comments.post_id) AS post FROM comments ``` Which returns `post` as a composite type....
I'm seeing some unexpected behavior and wanted to see if this was by design. I'm connecting via a pool and when I run a query with an error in it,...
Trying to connect with a `scram-sha-256` password fails (`error: password authentication failed for user ""`), while `md5` works. Environmnent: - Debian 11 - Node 17 - pg 8.7.1 - PostgreSQL...
Client.query(config, values, callback) sets config.callback, causing subsequent invocations to fail
Client.query(), when using promises (no callback), will via normalizeQueryConfig() set config.callback, which causes subsequent invocations of Client.query() with the same config to fail silently - no error message, just returning...
According to [docs](https://node-postgres.com/features/types), there is no special treatment required for JSONB bind arguments. In practice there is: * When the argument is a single object, it is bound correctly *...
In version 7.5.0 I set the client_encoding: 'latin1' and it works for ascii databases. In the current version it just returns some weird characters: Version 7.5.0: Supervision Version 8.7.3: Supervis�o....
Hey, We have a simple replicaset/master-slave configuration of Postgresql: 1 master and 2 slaves. Right now I can't see any option to connect to only master and make insert ops...
