I'm creating a login app and I get an error writing code in many ways, so I'm asking for help. The code now says to fill in three fields and fill in all fields when you press the login button.…
I recently restored an AWS RDS database from a snapshot, and it has the same database name as the original one, which I need to change for consistency and management purposes. My research suggests that there is currently no direct…
In my Postgres 13.10 database, I have a table menus with a JSON column named dishes. This column contains values in the following format: { "desserts": [ {"id": 1, "name": "chocolate cake"}, {"id": 2, "name": "banana split"} ], "appetizers": […
I have a table that has a column called id. The table name is called names. I need to show all the id's that have one or more records on the table, and the corresponding fields on the table. The…
Today I noticed that saving operations into one of the table is so slow. I ran query select n_live_tup, n_dead_tup, relname from pg_stat_all_tables and found info that my table has 3 336 as n_live_tup and 46 508 837 as n_dead_tup.…
I get this error when trying dynamically switch from mysql to postgresql: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "FROM" LINE 1: SHOW KEYS FROM wb_sales WHERE Key_name LIKE '%unique%'; Error occuring when I'm trying to upsert…
i have a problem connecting to my postgres. It is running in my Docker properly but i am not able to connect via python to that container. Additionally i get no error message. "e" is empty. Any idea why it…
I'm trying to create a trigger, where inserted certain value in column if one value "currentAttemptCount" becomes equal or more to another "attemptCountLimit" from another table i have two tables @Table(name = "course_items") public class CourseItem { @Id @Column(name =…
How to insert a million records into the database so that the system does not hang, and then twist the message that the page does not respond $rangeNumber = collect(range($validatedDate['from'], $validatedDate['to'])); $collectData = []; foreach ($rangeNumber as $number){ $collectData []…
I have a project with spring boot starter validations and recently added the driver to connect to a postgres database and the ddl-auto=create. When the application starts it is not able to create my table. I have two models with…