I have 2 tables: Events Attendance I wrote a function that gets triggered on every row insert or update in the Attendance table, to update "Event"."attendees_count" column by incrementing by +1 if it's an insert, decrement by -1 if attendance…
Yesterday I switched to Ubuntu 24.04 LTS from windows and having an issue with my django project and tried every suggestion on the web but no luck. I'm getting below issue: django.core.exceptions.ImproperlyConfigured: 'django.db.backends.postgresql' isn't an available database backend or couldn't…
I have columns id (string), parentId (string or null) and order (number). It's tree like structure where rows with the same parentId are children of the same node. order is used to sort children for each parent (so they might…
(This is my first time here so I'm sorry if this post is not perfect.) I have developed a Flask application which I have later deployed on an AWS EC2 instance. The app connects to RDS database (PostgreSQL) to handle…
Let's consider the database table for currency conversion looks as below: fromCurrency toCurrency effective date conversion rate USD INR 1-Mar-2024 80 USD INR 1-Jan-2024 85 USD GBP 1-Oct-2023 .80 USD GBP 1-Mar-2024 .85 USD AUD 1-Mar-2023 1.55 USD AUD 1-Mar-2024…
I have the query (PostgreSQL) which works correctly. with xml_test as ( select '<!--Build-Version: 1.564-REVb37dd024a8-20220530T1418--><tns:Message xsi:schemaLocation="https://appprod.be/Trivia/documents/Docs/XSDs/v1/T013 T013_v1.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tns="https://appprod.be/Trivia/documents/Docs/XSDs/v1/T013"> <Header> <Agent>90015299</Agent> <SocialFund>299</SocialFund> <MessageId>T013</MessageId> <Timestamp RequestDate="2022-06-16T23:20:00" ProcessDate="2022-06-16T23:25:20" ResponseDate="2022-06-16T23:25:20"/> <Reference NRK="6e6806740a6ea06d7ca6ae7b31edeb8e" Requestor="90010299"/> <Result>OK</Result> <ReturnCode>ResponseOnly</ReturnCode> </Header> <Body> <Request> <TransmissionMethod>BULK</TransmissionMethod> <SocialFundCode>299</SocialFundCode> <FileNumber>9913894</FileNumber> <FiscalYear>2020</FiscalYear> <FiscalHouseHolds>…
I have the next query, what returns me categories with an array of games that assignment to them. How can I limit number of games in that array? SELECT categories.*, COALESCE(jsonb_agg(g.*) FILTER (WHERE g.name IS NOT NULL), '[]') AS games…
Why I have problem like that? How did you solve that? I am trying to connect to postgresql import psycopg2 conn = psycopg2.connect(database="test", user="postgres", password="260508", host="localhost", port="5432") print("Database Connected....") in result i have error. Traceback (most recent call last): File…
I was trying to reset the password. r9mzsy20=# ALTER USER 9mz_dba WITH PASSWORD '92837474'; ERROR: syntax error at or near "9" LINE 1: ALTER USER 9mz_dba WITH PASSWORD '92837474.. For user u_9mz_rw and u_9mz_ro I was able to reset the…
I im trying to store GLTF file in a postgreSQL. I came up with an idea to convert file to byte array with memory Stream. But when i try to convert it back, from byte array to file with System.IO.File.WriteAllBytes…