No, it doesn't call any in-core code. The following is the code in 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."ComputerProfileId", t1."Trustee", t1."AccessControlType", t1."AceOrder" FROM ( SELECT a."ComputerProfileId", s."ADUser" "Trustee", 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" = a."ComputerProfileId" AND a."AccessRight" = 4 ) t1 On Mon, Oct 28, 2019 at 5:56 PM Michael Paquier <mich...@paquier.xyz> wrote: > On Mon, Oct 28, 2019 at 09:51:07AM -0700, ZhenHua Cai wrote: > > 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 > > ); > > The original complain comes from a function called ComputeComputer. > What does it do and where does it come from? Does it call any in-core > code which would cause the failure. If the function is a SQL > function, could you provide a self-contained test case? > -- > Michael >
