Collectives™ on Stack Overflow
Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about Collectives 0votes
0answers
27views
Connection to remote PostgreSQL server with hashtag in password with node-postgres
I have a password for a remote PostgreSQL server that I cannot change. This password contains hashtags (#). From searching, I know that this can be a problem.I can connect to the server from the ...
- 147
2votes
1answer
56views
Does the pg.Pool from node-postgres support acquireTimeoutMillis?
I'm having a hard time with an app that has some spikes in connections. I think if acquireTimeoutMillis was working these would be queued pre-database. Trying to set it in testing doesn't seem to be ...
- 920
0votes
1answer
39views
"Merge INTO" can't catch exists data
I have a problem about inserting datas to my table with "MERGE INTO" method.I am using a procedure to insert datas, and my datas come from array fields.My Table:CREATE TABLE IF NOT ...
- 3,340
1vote
1answer
61views
Node-postgres query to remove object from array
I'm building backend with Express and TypeScript. DB is Postgres, client is node-postgres.In DB I have table user_collection. This table has column collection of type JSONB. Collection column ...
- 215
0votes
1answer
163views
SET search_path on every user with database connection pooling
I have a question which may sound dumb but I have never done this before and have some questions that I cant seem to find the answer of.My project is in Next.js 14 with Kysely and node-postgres. I am ...
0votes
1answer
541views
Are PostgreSQL's cursors per connection or something else?
I'm using node-postgres (pg) and its pg-cursor extension. I noticed when reusing the same connection between multiple cursors, it locks due to what I would assume that a single connection is only able ...
- 192k
0votes
0answers
143views
How to fetch postgresql with pg-query-stream from server side?
I might be close, but not quite there yet as the below throws Error: Invalid response from route /api: handler should return a Response object, probably I do return just an object and not a Response?...
- 15
0votes
1answer
35views
Syntax Error in PostgresSQL When import pool into another file and run query
I'm trying to make connection with PostgreSQL and export it. When I import the pool into other file and run a query it throws the error: syntax error at end of inputpostgre.jsconst config = require(&...
15votes
3answers
10kviews
How to declare self-referencing foreign key with Drizzle ORM
In a Typescript project, declaring a table using Drizzle on postgres-node as follows:const contractsTable = pgTable("contracts", { id: serial("id").primaryKey(), ...
- 173
0votes
0answers
141views
Error: password authentication failed for user 'abc' when connecting to PostgreSQL database with node-postgres
I have a multi tenant node application. I'm encountering an issue when trying to connect to local PostgreSQL database using node-postgres. Whenever the program attempt to execute a function (...
- 863
0votes
1answer
48views
Semantically Identical JSONB Object Passed Into Postgres Function Cannot Be Parsed When Using Placeholders
I have two identical JSON objects.First ObjectSecond Object[{"id": 123,"firstname": "Mike","lastname": "Smith","ani": 123456,"email&...
- 2,097
1vote
0answers
61views
postman request doesnt show results and stuck on sending request
the problem may reside either in the /login route or in the local strategy but a post request to /login makes postman send infinitely and no results come back. i've searched a lot but there doesn't ...
- 21
0votes
0answers
175views
How do I fix a PostgreSQL order query (ASC/DESC) error (for complex queries) once I have seeded the database with data?
I am trying to do some complex queries in my bird database to get all the birds back but I want to be able to use queries in the url to get back by diet and to sort accordingly and order appropriately....
- 71
0votes
0answers
417views
How do you do a PATCH request on data seeded into a PostgreSQL database in JavaScript
In summary I have a bird database and I am trying to do a PATCH request on seeded data I have added using the node-postgres Pool object to create a database connection with a pool of clients. I am ...
- 71
0votes
0answers
377views
How to fix PostgreSQL error (42601) in my development database using node postgres I get with insert function
I am trying to an insert query of bird family data below ( using function insertIntoB_familiestbl) related to bird families into bird families table. But I am getting an error relating to the ...
- 71
- The Overflow Blog
- Featured on Meta
Hot Network Questions
- Difference between VOR approach (with DME required) and VOR DME approach?
- Low-Side Current Sense Simulation
- What damages are recoverable for late delivery of a package?
- In ITT, are all provable equalities in the empty context provable by refl?
- Can you help me identify this location from 1918?
- Using ASCII Art & pxpic
- When exactly does the game clock start during an American football kickoff?
- Cutoff times for Seoul City Air Terminal check-in
- Murphy's Theorem 3.3.2 on positive linear functionals
- Movie about two immortals: a young girl and an older guy. The guy would collect and kill people for the girl to feed on
- strange use of вышел
- Sum of the parts
- Can a chocolate bar contain alcohol naturally?
- Why did Jesus say that he is the light of the world while in it?
- What are the correct lyrics to the song "Lola", by The Kinks?
- How do we decide whether a vibration of a solid object is longitudinal or transverse, when the object is not a 1D rod or 1D string?
- A (probably wrong) proof that the fundamental Poisson brackets are independent of the special choice of the canonical variables
- Why is the verb "to sic" conjugated with a double c rather than the more typical ck?
- Detect if any ping succeeds
- Define Min and Max Values in Geometry Nodes Relatively to Another Mesh
- What is the difference between V-inf+ことない and V-stem+ない
- Condensation of water droplets on one side of a bottle!
- What is the point of All In?
- Is there a term for the sound the orchestra produces when they tune?