I apologize if this has been answered. I've searched repeatedly over years and have yet to find an adequate solution to actually terminate a session on a postgresql 13 server made by my python scripts. A simple example: from sqlalchemy…
Background I'm getting insanely slow queries when using small LIMIT clause values on a relatively simple query. I've already read and re-read PostgreSQL query very slow with limit 1. (not that I couldn't have missed anything, but it's related, and…
What I want: if record with the same unique(doctor_id, year, month) exists, we need to increase sum via input sum value. I'm trying this SQL query: with rows as ( insert into mis_doctor_stats (doctor_id, year, month, sum) values (1, 2025,…
I have a SQL query that looks like this: INSERT INTO testing.names ( id, first_name, active_status ) ------------------------------------- SELECT stage.id, stage.first_name, stage.active_status FROM testing.name stage ON CONFLICT ON CONSTRAINT names_pkey DO UPDATE SET active_status = excluded.active_status where active_status <> excluded.active_status…
I want to be able to search for people "similar" to what I have in the database (e.g. a person with a typo in their name or date of birth). I want to use the levenshtein function for that in…
I have a following SQL running in PostgreSQL v13.10: WITH stuckable_statuses AS ( SELECT status_id FROM status_descriptions WHERE (tags @> ARRAY['stuckable']::varchar[]) ) SELECT jobs.* FROM jobs WHERE jobs.status = ANY(select status_id from stuckable_statuses) And it is running really slow while…
Say I have a table with kids and their toys. CREATE TABLE kids_toys ( kid_name character varying, toy_type character varying, toy_name character varying ); kid_name toy_type toy_name Edward bear Pooh Edward bear Pooh2 Edward bear Simba Edward car Vroom Lydia…
I have a flyway script which creates a User in postgres with an encrypted password. I want flyway to create the user account, and then use the account with a springboot java application. I want to use an encrypted password…
Is it possible with the entity manager to save the name of the enum without using the name method? I need it because sometimes my enum will be null and then the name method would return a nullpointer. Now I…
I am receiving an error when I try to create a generated tsvector column that has a timestamp included. The error is `ERROR: generation expression is not immutable SQL state: 42P17` Here is the generated column I am trying to…