Re: PostgreSQL - unrecognized win32 error code: 38

2019-11-19 Thread Thomas Munro
On Wed, Oct 30, 2019 at 12:13 AM Thomas Munro wrote: > On Tue, Oct 29, 2019 at 9:23 PM ZhenHua Cai wrote: > > No, it doesn't call any in-core code. > > I wondered if this could be coming from the new code in > src/port/pg_p{read,write}.c. ERROR_HANDLE_EOF is a documented > GetLastError() return

Re: PostgreSQL - unrecognized win32 error code: 38

2019-10-29 Thread Thomas Munro
On Tue, Oct 29, 2019 at 9:23 PM ZhenHua Cai wrote: > No, it doesn't call any in-core code. I wondered if this could be coming from the new code in src/port/pg_p{read,write}.c. ERROR_HANDLE_EOF is a documented GetLastError() return value after ReadFile() fails[1], but only for asynchronous files.

Re: PostgreSQL - unrecognized win32 error code: 38

2019-10-29 Thread ZhenHua Cai
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 "GenericR

Re: PostgreSQL - unrecognized win32 error code: 38

2019-10-28 Thread Michael Paquier
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

Re: PostgreSQL - unrecognized win32 error code: 38

2019-10-28 Thread ZhenHua Cai
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

Re: PostgreSQL - unrecognized win32 error code: 38

2019-10-27 Thread Tom Lane
Michael Paquier writes: > On Sat, Oct 26, 2019 at 11:02:26AM -0700, Adrian Klaver wrote: >> Not sure how that can be answered without knowing what ComputeComputer is >> doing? > Yes, there is nothing of this kind in the PostgreSQL code. Sure there is: win32error.c produces exactly that message i

Re: PostgreSQL - unrecognized win32 error code: 38

2019-10-26 Thread Michael Paquier
On Sat, Oct 26, 2019 at 11:02:26AM -0700, Adrian Klaver wrote: > Not sure how that can be answered without knowing what ComputeComputer is > doing? Yes, there is nothing of this kind in the PostgreSQL code. So you may want to check your own extension code if a module is involved here, or perhaps

Re: PostgreSQL - unrecognized win32 error code: 38

2019-10-26 Thread Adrian Klaver
On 10/25/19 5:19 PM, ZhenHua Cai wrote: 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

PostgreSQL - unrecognized win32 error code: 38

2019-10-26 Thread ZhenHua Cai
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: