I'm trying to use the ARRAY datatype for Sequelize (Node.js SQL ORM) with PostgreSQL. However I'm not exactly sure how to utilize it. I know how to set it on th
I want to transfer the query to TypeORM. It looks like this in Postgres SELECT * from equipment_charging where (equipment_charging."start_date"::date, equipme
I already have my server application written in Node, PostgreSQL, Sequelize using Fastify. Now I would like to use TypeScript. Can anyone tell me how to begin
Hello i have an issue with my app Rails when i try to create an "Enfant" who belongs to an user and a Nounou but my problem is when i create an "enfant" i'm a u
I have set database with postgresql and docker, now when I want to access to my database I have this connection error saying password authentication failed for
How can I return a simple jsonb object in a PostgreSQL function written in C? I don't know enough about postgres server side programming. And below is my attem
I need to extract a number of characters from one column to another and insert it into another column number_operation communication test B003-00000005 FCI-
I'm trying to use pg-mem with the pg-promise adapter for testing my database layer. Initially I've tried fetching a fresh database for each test: import { newDb
I've created a schema in my PostgreSQL database that Hibernate uses, creating tables, persisting entities and so on. After I updated my Ubuntu 14.04 to 16.04, I
I try to register pg-promise as hapi plugin. However, the following error occurred. TypeError: Cannot read properties of undefined (reading 'name') at interna
If the parameter autovacuum is on, and the parameter track_counts is on also - why it's look like the autovacuum has never worked? select relname,last_vacuum,
I received the following error when trying to write session data using Tomcat's PersistentManager to a Postgres DB running on my local machine: SEVERE: A SQL
I have a business requirement to select records based on two fields in one table: code1 and code2. The selection is complex and hard-coded, with no codeable rhy
I know this may seem like a duplicate of docker-compose with multiple databases, but I still can't manage to get it working after going through the answers. He
Hibernate 6.0.1 with PostgreSQL JDBC driver 42.3.5 causes the following exception: java.lang.UnsupportedOperationException: CteInsertStrategy can only be used w
This issue is totally driving me insane. I spent months with this, trying to make a SIMPLE NODE APP WORK. I finally managed to make an APP work in a nice server
When I try to open psql with this command: psql -U postgres I get this error: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" f
How can I configure Azure PostgreSQL database in Django settings.py using Managed Identity in Azure?
What would be the benefit of using a struct like below with pointers instead of a struct without pointers when scanning from database? type User struct {
What kind of problem is that? Does anybody face this? Or anyone knows the solution? I was trying to deploy ktor server using PostgreSQL. Exception in thread "ma