Re: PostgreSQL - unrecognized win32 error code: 38

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 <michael(at)paquier(dot)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
>