879 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
519
views
Next.js - TypeError: Cannot read properties of undefined (reading 'searchParams')
I am trying to get my database connection to run querys but it refuses and runs the error I provided in the title. I didn't change anything and even reverted back a few commits to see what happened ...
0
votes
0
answers
110
views
Using PGlite and retrieving rows as a JSON string for processing
I'm using PGlite and querying the table using Results<T> Objects, returning the result as a JSON string to be processed by my Gleam lustre code.
export function getData() {
let parsedResult;
...
0
votes
2
answers
81
views
After updating a trigger in PostgreSQL, it updates all the records instead of specific records
I have a trigger to update a field when there is an update performed on a table. But the trigger updates all the records in the table instead of specific records.
Trigger
create or replace trigger ...
2
votes
2
answers
91
views
What happens when application thread shuts down while having a row lock in postgresql?
If application has acquired row lock and is performing transaction, when shut down (eg. power outage) what will happen to the locked row? Is the lock turned off and whole transaction is rolled back?
0
votes
0
answers
132
views
How to use pg Pool in node js nest js with typeorm
I already have a Node.js application using NestJS with TypeORM configured. Now, I want to implement a PostgreSQL connection pool using pg Pool for better database connection handling. Is it possible ...
1
vote
1
answer
463
views
My database connection closes in middle of operations
I am running FastApi with SQlAlchemy and PGBouncer, I keep getting asyncpg.exceptions.ConnectionDoesNotExistError: connection was closed in the middle of operation. This happens randomly and I have ...
0
votes
0
answers
647
views
Node.js app with PostgreSQL running in Docker — enabling pgvector, but the app is looking for the vector.control file in the wrong location
I have a node js app running on my local machine connecting to postgresql running as a docker instance. I am trying to get pgvector working in the postgres docker instance but am receiving a file / ...
1
vote
0
answers
219
views
Issue with Node-PG-Migrate and Incorrect Database Name
I'm using node-pg-migrate for my migrations, and I've set up my .env file with a custom database name, but when I run the migration command, it always tries to connect to a database with my PC's admin ...
1
vote
0
answers
49
views
PolarDB 11 compiles pg_bulkload plugin but reports an error
I am encountering a compilation error when trying to build the pg_bulkload plugin with PolarDB 11. Here's a detailed description of the steps I followed and the errors encountered
Reproduction Steps:
...
0
votes
0
answers
55
views
Failed to connect to the database error: invalid page in block 22 of relation base/12971/2674
I am trying to run in-memory Postgres using pgmock, the connection is getting established but getting this error while running any query.
Failed to connect to the database error: invalid page in ...
0
votes
0
answers
24
views
Could pg notice be discarded in NiFi?
My NiFi flow calls pg functions. For debugging purpose multiple raise-notice statements are embedded in pg functions. while handling huge dataset, they generate abundant text output for programmer. ...
0
votes
1
answer
69
views
Whether aiopg supports ORM frameworks such as SQLAlchemy
The official handbook only has instructions for SQLAlchemy core; I'm not sure if aiopg supports the ORM framework.
I checked it up, but there wasn't enough information. asyncpg is known to support ORM....
3
votes
2
answers
1k
views
Nuxt 3 & Postgresql: Cannot access 'renderer1ドル' before initialization
I am working locally on an application built with Nuxt.js 3 and using Postgreql. I am finding that I am running into the following error message: Cannot access 'renderer1ドル' before initialization
1: No ...
0
votes
1
answer
103
views
Error with pg in Jest-ts testing : Jest has detected the following 1 open handle potentially keeping Jest from exiting: ●くろまる TCPWRAP
I have been facing the problem where my Jest test is not ending gracefully. (I prefer not to use --force-exit).
this is my jest code. FYI the tests passes. This is an integration testing.
import ...
2
votes
0
answers
534
views
Drizzle: there is no unique or exclusion constraint matching the ON CONFLICT specification
import { sql, type SQL } from "drizzle-orm";
import type { AnyPgColumn } from "drizzle-orm/pg-core";
export function lower(col: AnyPgColumn): SQL {
return sql`lower(${col})`;
}
...