We have a function that builds a summary table and takes about 50-130 secs on average depending on data like so Truncate table summaryTable ; -- multiple insert statements and couple of loops... insert into summaryTable ..... The process fails…
I have a tickets table (Postgres on Heroku) that has about 7 million records. I have a single table query that is run often with the exported field either true or false. When it is true, it runs very fast…
I have all my reports built in Power BI Desktop, using its native PostgreSQL DB connector to retrieve data. The source is a Neon Tech PostgreSQL instance. Now, during an update, I receive the error: "PostgreSQL XX000: Insecure connection: try…
I recently downloaded PostgreSQL on Mac and after successful installation when I start pgAdmin 4, it is giving me this error "_LSOpenURLsWithCompletionHandler() failed with error -10669". Screenshot of the error is also attached here. I downloaded the Mac version 17.0…
I am trying to implement an appointment manager for a dentist office. Thing is I am not sure how to properly implement such function. Right now I have managed to create these two tables that will handle it: CREATE TABLE…
I'm using TypeORM with NestJS to establish a one-to-one relationship between two tables, but when I view the ERD in pgAdmin, it's showing up as a many-to-one/one-to-many relationship instead. I have included my code snippets and an image of the…
Simple question, but I can't seem to find a simple answer. Step 1: I pass this into the postgresql function as json: { "name" : "John Doe", "convert" : [32197,4234523,4235423] } Step 2: I would LIKE to store the id…
I'm looking for a value in Postgres similar to "-infinity"/"infinity", but for string values, which can be used in a WHERE clause, for example, WHERE "name" > 'infinity', which should always return false. Ideally, this value would work regardless of…
Given a postgres table containing the following items: tag_id, duplicate_tag_id, tag_created_at_timestamp 14175, 14178, ... 14175, 14177, ... 14176, null, ... 14177, 14178, ... 14178, 14179, ... 14179, null, ... 14180, null, ... 14181, null, ... Is it possible to write…
I have a table with an id and the json column prod as the structure below { "1": { "product": "chain", "spare_part": [], "sp_done": 0 }, "2": { "product": "bike", "spare_part": { "1": {"part": "pedal", ...}, "2": {"part": "switch gear",…