I'm trying to create a table on destination DB from source db using it's load function. As a documentation SymmetricDS_load it should seed the table on the destination DB but it's keep giving me this error [master-engine] - DataService -…
I am using SQLAlchemy and PostgreSQL, and I am trying to create a case-insensitive unique constraint that works like this UniqueConstraint( 'country', 'organisation_id', func.lower(func.trim('name')), name='uq_country_orgid_lower_trim_name' ) Ensuring a unique combination of name, country and organisation id, regardless of case and…
I'm attempting to call a database function that takes a single UUID as a parameter. When I do this: report_id = "5ed30f08-0de0-47f4-99e8-9aeeb8eb2dfe"; query = "select * from public.fn_func($1)"; report_nav = pq_exec_params (conn, query, {report_id}); I get this: __pq_exec_params__: fatal error:…
We are trying to implement strong password policies to our aws hosted postgresql RDS instances using TLE (https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/PostgreSQL_trusted_language_extension-hooks-reference.html) I wanted to implement valid_until parameter so how whenever password is changed by user using PGAdmin its account expiry is automatically extended…
Problem in calculating the age of majority of a student in Spring Boot I have a Student class with the following attributes: package com.example.estudantes.model; import jakarta.persistence.*; import lombok.Getter; import lombok.NoArgsConstructor; import lombok.Setter; import java.time.LocalDate; import java.time.Period; @Entity @Table(name = "students")…
I have an entity that looks like this @Entity @IdClass(AId.class) class A { @Id private String userName @Id @NotNull @JoinColumn(name = "location_id", referenceColumnName = "id", nullable=false, foreignKey = @ForeignKey(name = ...)) private Location location; private String userInformation; } The class…
Postgresql allows NaN values in numeric columns according to its documentation here. When defining Postgres tables using Django ORM, a DecimalField is translated to numeric column in Postgres. Even if you define the column as bellow: from django.db import models…
It is well known that using ORDER BY in a subquery in PostgreSQL is not meaningful, and the DBMS will only respect the outer most ORDER BY. However, if we include LIMIT (alongside ORDER BY) in the sub query, is…
I have an postgres 16 DB in Docker container with volume. I wanted to hide standard postgres user and changed it's name to super (as example). Now I try to make something with any tables (DDL operations like ALTER TABLE)…
I can simply use LAG() to calculate the percentage change from my table (see below) of this month compared to the data 3 months ago or 1 year ago. But now, I want to get this result: calculate the sum…