postgres

postgres copied to clipboard

Never-ending CONNECTION_CLOSED errors

1

I'm putting this here since [the docs state](): This should not happen during normal operation, so please create an issue if this was unexpected. So, my node projects makes about...

TimChinye

How can I get the length of pending queries? Looking at this file: https://github.com/porsager/postgres/blob/f58cd4f3affd3e8ce8f53e42799672d86cd2c70b/src/connection.js#L71 I tried to use that `sent` object but the connections array is not assigned to sql...

Langsdorf

Hi. I recently migrated from node-postgres to postgres.js and ran into the issue that my script would never finish as the connection was still open and therefore block the node...

matthiasfeist

I am using a postgres client to run COPY on the server to stdout into a readable stream. I am using pipeline and noticing that sometimes pipeline hangs indefinetly due...

Ivor808

No overload matches this call

1

The following snippet is generating an error: ```typescript import client from "./driver"; export interface Course { id?: number; name: string; description: string; price: number; image: string; } export interface UpdateCourse...

AlvaroParker

Problem executing Common Table Expression (WITH query)

4

Hello, Driver fails to execute WITH query as below: ```typescript const translation = [["en", "My Label"], ["ru", "Моя Метка"]] console.log(translation) const id = (await sql` with t as ( insert...

aplatoff

Adding PGAPPNAME Environment Variable

2

Making it possible to set the application_name with the PGAPPNAME environment variable. This is a standard set by the Postgres team (https://www.postgresql.org/docs/current/libpq-envars.html). It is a nice to have feature, and...

gimse

Is there a way to get the number of available database connections? I need this number to use for monitoring the performance in the company I work for.

patrickReiis

PGPASSFILE not working in Node.js

2

I created a .pgpass file in the user's home directory: > vi ~/.pgpass\ I added the connection details: > 182.10.203.23:5432:database:username:verystrongpass\ I then tested the connection using psql and it successfully...

jcpc91

Fix ambiguous error on startup

3

Fixes https://github.com/porsager/postgres/issues/923 Before & after: 

alexgleason