I have tried to solve how to deploy Django project on Azure, been following many tutorials but in this point i cant point whats the issue. Deploying from GitHub, deployment have been success whew times but i cant to access…
Merge /*+ parallel (16)*/ into psx_cluster_audit_t_1 a using psx_cluster_cross_ref_t_1 b on ( a.psx_id=b.RECORD_ID and a.PSX_BATCH_ID=b.PSX_BATCH_ID and b.psx_batch_id='2411121519014999' ) when matched then update set mpc_new=b.mpc where a.mpc_new is null The above query giving: SQL Error [42601]: ERROR: syntax error at or…
I use a table with a section based on date. The primary key index is built on the id and open_date. If I use the date from the subquery, the planner will search through all partitions. > EXPLAIN analyze SELECT…
I have the following two tables table c id type 1 B1 2 B2 3 B3 table s id s_id s_type 1 2 C1 2 2 C2 3 3 C2 Now I want to insert new rows in the table…
DROP TABLE IF EXISTS A; CREATE TABLE a (id int); CREATE or replace FUNCTION insert_and_return(int) RETURNS int AS $$ BEGIN INSERT INTO a VALUES ($1); RETURN $1; END; $$ LANGUAGE plpgsql; SELECT * FROM insert_and_return(10),A AS y; Above code has…
I have a dump.sql file that I want to restore to a local database on my machine. However, when I try to import it, I get an error saying all schemas, functions, relations, constraints, roles are already exist, even though…
I have a bidirectional ManyToMany mapping, and I am trying to delete a post entity. When I delete it, the reference in the posts_categories table should also be removed. However, despite trying the following two approaches, it’s not deleting the…
I often find myself wanting to run a query like this on multiple different databases: select n, pg_size_pretty(s) from ( select n, pg_total_relation_size(n) s from ( select format('%I.%I', table_schema, table_name) n from information_schema.tables ) ) order by s desc; How…
The following works fine: conn = psycopg.connect(self.conn.params.conn_str) cur = conn.cursor() cur.execute(""" SELECT 2, %s; """, (1,), ) But inside a DO: cur.execute(""" DO $$ BEGIN SELECT 2, %s; END$$; """, (1,), ) it causes psycopg.errors.UndefinedParameter: there is no parameter $1…
I have a query like: SELECT DISTINCT ON (services.group_id) services.service_id, ... FROM services WHERE services.group_id IN ('67240181b97477f054f9b1bc', '67240181b97477f054f9b1be') I have an index on group_id. Why does Postgres need to do an extra heap scan? I just want any 1st match…