I get the following error when trying to connect to postgres as a target using AWS SCT: LOADER ERROR: Error executing 'load-contexts' query: org.postgresql.util
I have a table with users: id referred_by_user_id ----------------------------------- 1 null 2 1 3 1 4
I have an RDS multi-AZ postgres database (primary-standby) and I'm investigating Debezium to stream changes to Kafka. I was reading the documentation of what co
I did this class to do the inserts but every time I need insert again, I need initialize the method main of this class again. Because it is in just one cycle. p
My typeorm version is 0.3.6. Whenever i tried to use dataSource.runMigration() i get this error, MIGRATION ERROR:CannotExecuteNotConnectedError: Cannot execute
What is the shortest Pgsql query to get all records that contain a line-break in a given column ?
I'm trying to check if an user already have a email. I wrote a function like this : func IsUniqueEmail(body io.ReadCloser) (database.User, error) { connection :
We were using older Liquibase that we now wanted to update to 4.9.1 due to vulnerabilities in older versions. However, now at least one of our old migrations fa
I’m doing; createdb -O dan -h 127.0.1.1 -p 5432 -U dan -w testdb but it throws me: fe_sendauth: no password supplied Then I tried to remove -w and it a
In my NestJS application with postgres db I have these 3 entities: User, Writer, Book and a class named UserBaseEntity. export class UserBaseEntity { @Prim
I have a table "studies" with 14 subtables that are connected to "studies" via a foreign key that refers to the primary key in "studies". I need to delete all r
I am trying to take a backup from Odoo enterprise 14 through query. When I try to export the dump file I get this message Can anyone guide me, how to export all
I want a postgresql function that will take a list of arrays, and loop through them. I have written a "hello world" type function that takes a single array and
I implemented cursor pagination. And for first rows it works realy well but the more I scroll down, the first query I send is slower. I run this query: SELECT *
I have a task to import some data from Postgres database to Oracle via dblink The connection between Postgres and Oracle works good, but unfortunately, when I t
I'm trying to reference columns in JOIN tables of a subquery from an aggregate function, as follows: WITH my_activities AS (SELECT activities.*, owner.*
I'm building a web app to manage a fleet of moving vehicles. Each vehicle has a set of fixed data (like their license plate), and another set of data that gets
I am using HIVE and I have a table like this: S.no ID applicant_num f_name l_name Primary Key 1 123 202201A1 akhil yadav 123~&~akhil~&~yadav 2 123 2022
we are trying rxdb as local database and postgresql as a server database and through graphql end point we are able to push and pull data from local to server an
I have a PostgreSQL used to index text content. The SearchVector column is created successfully using the following code UPDATE public."DocumentFiles" SET "Sear