I have a Subject class and a Course class. They are in a many-to-many relationship so I also have a CourseSubject class with navigation properties and id properties to the other two classes. I can now read subjects and courses…
I am creating an webshop app. I have a tech shop with products that are for example CPUs, GPUs, keyboards, mouses etc. All of them have common attributes - id, description, name, but also their own, custom attributes - mouses…
I would like to update values in one postgres table from values in another postgres table, but I would like to update only values which NEED to be updated - ie if a value is already correct, leave it alone…
(I had originally asked this question on the DBA StackExchange, but didn't get much activity in it). In my DB, I have tables for items and connections between them, creating a likely sparse graph, with islands: CREATE TABLE IF NOT…
I can't access my postgresql datatabase because I forgot my password for PostgresSQL super user. What do I need to do? I must enter pass when try to uninstall PostgresSQL or open psql database in terminal.
I have the following query which I'm unable to solve: SELECT DISTINCT m.id, TO_CHAR(m.date, 'YYYY-MM-DD')::timestamp AS formatted_date, FROM table.match m In the formatted_date field I get the following output: 2012-12-02T00:00:00.000Z Does anyone know how to format it as to get…
When I try to load a Redis database with Redis Stack 7.2 from an RDB file which has been created with a prior version of RS, it does not load, printing this error: * Loading RDB produced by version 6.2.13…
I have a table called Configuration: CREATE TABLE "Configuration" ( "id" CHAR(36) NOT NULL, "namespace" VARCHAR(255) NOT NULL, "key" VARCHAR(255) NOT NULL, "value" JSONB NOT NULL, "level" "ConfigLevel" NOT NULL, "userId" CHAR(36), "orgId" CHAR(36), "teamId" CHAR(36), "moduleId" CHAR(36), "moduleSubscriptionId" CHAR(36),…
In one of my Postgres Transaction (executing a procedure), I'm using more than 50 temp tables and for each temp table it is creating pg_toast_temptableOID, pg_toast_temptableOID_index with AccessExclusiveLock and fastpath = false for these pg_toast tables. It is creating slowness…
I have started the working on transaction concept of database but, I don't know when to use transaction and when we should not? Suppose, If I am running simple SELECT * FROM table_name query. So, Do I have to use…