Hi All
I encountered one problem. It repeats again and again. Please help.
"ComputeComputer" is one stored procedure. The version of PostgreSQL I am
using is 12.
2019-10-26 07:36:58.880 HKT [5376] CONTEXT: SQL function "ComputeComputer"
statement 1
2019-10-26 07:36:58.880 HKT [5376] STATEMENT:
The following is the SQL statement of that function.
DROP TABLE IF EXISTS "GenericReadList" ;
CREATE TEMP TABLE "GenericReadList"(
"ComputerProfileId" int NOT NULL,
"Trustee" uuid NOT NULL,
"AccessControlType" smallint NULL,
"AceOrder" int NULL
);
INSERT INTO "GenericReadList"
SELECT t1."Compute
a."AccessControlType",
a."AceOrder" FROM "TmpResult" r
INNER JOIN "TmpTrusteeSid" s ON s."ADUser" = r."Trustee"
INNER JOIN "AccessRights" a ON a."TrusteeSid" = s."Sid" AND
r."ComputerProfileId"
