I am simply trying to make some modifications to my postgres function. The liquibase logs report "Stored Procedure created", and show the changeSet id as expected, but when I check the database objects the function still has the old code.…
I have a jsonb column which has 'created' property and stores timestamp string. I'm able to query in query editor, but I can't perform the same using Spring Data JPA with nativeQuery as true. Here is what I'm trying to…
I'm trying to create an insert script to insert multiple rows and using "exists" condition, but it's returning me an error, and I don't know why, I have a query like this: INSERT INTO films (id, code, title, did, date_prod,…
I am trying to connect to my postgres db hosted on AWS RDS. But somehow I am getting the below mentioned error. pg_hba.conf entry for host "103.215.537.148", user "dbmasteruser", database "postgres", no encryption I am using postgres 15.2 I have…
I want to count duplicate rows such that the function only gives the redundant count not the whole count, for example: when a row appears three times and the count function returns 3, the row is only redundant by 2…
I want to prepend a string to the uuid generated by PostgreSQL's gen_random_uuid() to use as the uuid for one of my models (it won't be the primary key). Think like Stripe's price and customer ids - "price_xxxx..." and "cus_xxxx..."…
I want to combine two updates based on different condition into a single statement but getting an error and don't understand any other way. UPDATE "Main" SET status = true WHERE uid IN ( SELECT uid FROM XYZ ) UPDATE…
I see lots of slow COMMITs in my logs : 2023-10-06 14:35:47 CEST Tx[0] cmd[COMMIT PREPARED] PID[16591] DB[db_XX] LOG: duration: 1049.941 ms execute <unnamed>: COMMIT PREPARED '131077_AAAAAAAAAAAAAP//ZGKVXjMhkrRlCESsBTdiSzE=_AAAAAAAAAAAAAP//ZGKVXjMhkrRlCESsBTdiWAAAAAQAAAAA' 2023-10-06 14:35:47 CEST Tx[0] cmd[COMMIT PREPARED] PID[24320] DB[db_XX] LOG: duration: 1049.209 ms execute…
I have working listens_for function, which inserts LoadHistory object before updating Load: @event.listens_for(Load, 'before_update') def before_update_load(mapper, connection, target): current_load_select = select(load_fields).where(Load.id == target.id) insert_history = insert(LoadHistory).from_select(load_history_fields, current_load_select) connection.execute(insert_history) And the task is to have similar function but which will insert…
I have a table with year, area codes and each area code has 5 categories of age groups with people count as below. year areacode agegroup persons 2021 code 1 20-29 5 2021 code 2 30-39 11 2022 code 1…