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
In a Swift app, how does one connect to a Postgres database server? In Java, we use JDBC with an compliant driver to connect to a Postgres server, communicate
I need to pull out first date and last date of the month from the given from_date and to_date as input, For Example:- I have my psql output table as the followi
I have develop a project with Django/Docker/Postgresql and use docker-compose to deploy on a linux remote server. I want to deploy 2 apps based on the same code
I was testing some queries at pg9.4 in "JSON mode", and now I am checking if pg9.5 will bring all same JSONB functionality... But there are no row_to_jsonb() fu
I want to calculate Percentage of a value in Group by. My Table data salesId salesAmount productName salesTyp ------- ----------- ----------- ----
im just starting using databases and I'm working with PostgreSQL using Dbeaver. When I want to create database,i need to create a new connection ,so I select Po
I'm trying to parse postgres db credentials, the format is as follows: postgres://usernname:password@hostaddress:port/databasename I'm calling a method which r
Current situation So I have WAL archiving set up to an independent internal harddrive on a data logging computer running Postgres. The harddrive containing the
I'm hurting my head again this : On postgresql, I would like to get the local time for a given timezone. So, at 15:45 GMT, I want 16:45 for +01:00, but I can't
I am trying to run my project tests in a docker container. All of the tests work just fine when running locally. Errors started occurring when I tried to move m
I have 2 tables: table "person" with columns: person_id, person_name table "pet" with columns: pet_id, owner_id, pet_name person data: 1, 'John' 2, 'Jill' 3,