in spring boot, i wanna have nested records, because if that i need to use multiset in my selects. then i need to order the whole query by fields in my multiset. but the problem is that i get a error ...

Table has index on name column: CREATE TABLE firma2.klient ( kood character(12) primary key, nimi character(100), ... ); CREATE INDEX IF NOT EXISTS ...

I tried this code: CREATE OR REPLACE FUNCTION public.t4(in iid int, OUT n1 text, OUT n2 text) LANGUAGE plpgsql AS $function$ BEGIN SELECT DISTINCT n1=l.name, n2=l.comment from ...

For testing Prisma, I used prismock or prisma-mock . But those packages are compatible with Prisma version 6 or earlier. I visit the Prisma Official website, and they are suggesting using jest-mock-...

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 ...

I have a graph given by 2-element sets of points, say in a table CREATE TABLE edge_set ( INTEGER edge_set_id, INTEGER point_id ) I want to determine the graphs connectedness components. These ...

I’m trying to understand when to use a static background worker vs a dynamic one in PostgreSQL. From what I know so far: Static workers are registered during postmaster startup Dynamic workers can be ...

I am working on a highload system, which needs to process quite a lot of events, but not an insanely huge amount. The data ingested has to be editable during a short period of time, and then the need ...

I have a class with a collection of enums mapped into PostgreSQL native enum: internal class EventStackFilter { // other properties omitted public List<EventStackEventStatus> Statuses { ...

I have sets identified by a set_id, say: CREATE TABLE sets ( INTEGER set_id, INTEGER element_id ); I need a SELECT statement that finds the sets that are maximal with respect to the subset ...

I am getting into the world of self-hosted applications and I am trying to run a Production PostgreSQL on a VPS - Hetzner. So far I have been using AWS RDS and everything has been working great - ...

I activated pgaudit on my Cloud SQL instance by adding the two flags enable and pgaudit.log, and I immediately saw audit logs in Cloud Logging without having to create the extension. When I connect to ...

Im having an issue with supabase postgres changes. I have a subscription on frontend to watch for changes on a table using RLS policy to only see the changes of the current user. The problem that im ...

enter image description here I’m trying to install PostgreSQL on Windows, but the installation fails during the post-installation step. During setup, I get this error message: A problem occurred ...

I use docker-compose to run airflow. Postgres section is postgres: image: postgres:12.16 environment: - POSTGRES_USER - POSTGRES_PASSWORD - POSTGRES_DB healthcheck: test: [ "...