? How can I extract hierarchy linkage from paired parent-child columns in Postgresql?
aid bid 1 2 1 3 2 3 3 4 5 6 7 8 8 10 8 9 I would like to extarct the hierarchy linkage for aid and bid. No need to show each path, any id should show…
Can an index be created & used in a Postgresql transaction?
I have a slow delete query. As suggested here when I add an index I get much better results. Beside this scenario I don't need this index, so what I did is: Added the index. Deleted the rows. Dropped the…
Can Table A’s Grouped Results in PostgreSQL be sorted by Last Update Date?
I have two PostgreSQL tables, 'A' and 'B', with the following structures: Table 'A': id: primary key with auto-increment res_id: foreign key referencing table 'B' description: table description last_update: date type Table 'B': id: integer primary key with auto-increment description:…
Can NullPointerExceptions occur when passing inputs from scala.html to Controller as form in Play framework(2.8.*) Java?
I'm working in creating a java web app using play framework(2.8.19). While creating registration page I'm trying to pass the inputs from the registration page(scala.html) to the controller class where it saves the input to the Postgres table. Here I'm…
How can we rewrite this?
Currently I'm using a timer with node-schedule to check for changes in the database, making queries every 1 minute and then comparing with the information already registered to see if there were changes since the last check. With what I…
Amazon web services – Terraform RDS upgrade from 10 to 14
I am upgrading my RDS postgresql from 10.21 to 14.4 by creating a new family group as well , my idea is to create new family group and upgrade the rds with new family group and then delete the old…
save geometry type data with timestamp in postgresql
I want to save LineString like the below in Postgresql {"type": "FeatureCollection", "features": [{"type": "Feature", "properties": {"style": {"color": "#19f3e7", "weight": 2}}, "geometry": {"type": "LineString", "coordinates": [[50.998085021972656, 35.83528137207031, 1000.0, 1682083948.0], [50.99810028076172, 35.83527374267578, 1000.0, 1682083948.0], [50.998023986816406, 35.835289001464844, 1000.0, 1682083948.0]]}}]} [50.998085021972656, 35.83528137207031, 1682083948.0]…
How do I install my Postgres driver properly in Java? I get java.lang.ClassNotFoundException: org.postgresql.Driver from "java Main"
I am a beginner in Java coming from four years in JavaScript and Python. My goal is to run my Java program that connects to Postgres and create a table. My expected result is that java Main will output this…
Postgresql – Selecting a range of days across multiple years
I have a problem that involves the WHERE clause of my query: ... WHERE distinct_policy.policy_created_date_time between '2023-03-01' and '2023-03-11' The column "policy_created_date_time" is a timestamp without time zone. I want to select only ten days (first March - tenth March),…
PostgreSQL Record Involved Table Activities
Recently I came to a new challenge to understand a new ERP system and the tables involved when different business functions are taking place. I need to find the tables involved by each function. For example, if we have a…