How to change column type in PostgreSQL from text to array and cast only non-null values?
I have a table in PostgreSQL: | id | country| type | | 1 | USA | FOO | | 2 | null | BAR | I want to change the column type for the country column from text to…
Postgresql – Why Postgres is doing "Index Scan Backward" to get max ID?
I am running a simple query to get the max ID in a table: SELECT max(ID) FROM t WHERE m=345; Table (t) has 20 million records and 2000 distinct values for m. There is a primary key index on ID…
Postgresql – Condition filtering SQL
I have a table Table name - commands id name status group_id id - number name - string status - 0 or 1 group_id - number I need to sort as follows: for all elements with the same group_id I…
Postgresql – django modified_at field with database level auto update
I need to have modifed_at fields in my Django project. A field that updates every time a row updates in the database, despite where the update comes from: through calling .save() or through queryset.update() or even when updates happen in…
How to find records in PostgreSQL matching a combination of a pair of nullable String columns
Suppose a PostgreSQL table, articles, contains two nullable String columns of name and alt_name. Now, I want to find records (rows) in the table that have a combination of String name and alt_name matches another combination of the same type…
Postgresql – How to use WHERE with virtual column name added with UNION?
SELECT '1000000' AS number UNION ALL SELECT '541' AS number UNION ALL SELECT '-500' AS number UNION ALL SELECT '100' AS number UNION ALL SELECT number, 'biggest' AS result WHERE number = 1000000 How to make this work? My task…
Postgresql – Create a stored procedure to Delete Records postgres
I have created a function to delete multiple records.In our table contain id as type uuid. We get the input is like array of ids. CREATE OR REPLACE FUNCTION public.deletetVersion(item_list uuid[]) RETURNS TABLE(id uuid[]) LANGUAGE 'plpgsql' COST 100 VOLATILE PARALLEL…
How to connect to a postgres database in a docker container?
I setup my django and postgres container on my local machine and all working fine. Local server is running, database running but I am not being able to connect to the created postgres db. docker-compose.yml version: '3' services: web: build:…
Postgresql – Odoo 14, issue when trying to computing bank balance in treasury module
i got work to fix error when computing but i still dont have idea how to fix it because i'm still newbie Odoo Server Error Traceback (most recent call last): File "/home/equipAccounting/equip/odoo/addons/base/models/ir_http.py", line 237, in _dispatch result = request.dispatch() File…
Postgresql – SQLAlchemy Error '(psycopg2.errors.NotNullViolation) null value in column "id" of relation
I am aware of a similar issue How to fix error: (psycopg2.errors.NotNullViolation) null value in column "id" violates not-null constraint? but the answers there did not fix my error I have the following sqlalchemy structure connected to a postgres database…