Aida64 connection error to PostgreSQL database!!!

[Geek]

Version:AIDA64 Businell v7.70.7500

Language: Chinese

Datebase: postgresql-17.6-1-windows-x64.exe

ODBC: psqlodbc_x86.msi

SQL: 

/* I just added IF exists to the official SQL script statement, nothing else changed */

DROP TABLE IF exists Item;
DROP TABLE IF exists Report;
DROP TABLE IF exists NextID;

CREATE TABLE Report (
  ID             INT PRIMARY KEY,
  RVersion       VARCHAR(255),
  RHost          VARCHAR(255),
  RHostComment   VARCHAR(255),
  RUser          VARCHAR(255),
  RLocation      VARCHAR(255),
  RDateTime      VARCHAR(16),
  RComplete      SMALLINT
);

CREATE TABLE Item (
  INum           INT,
  IPage          VARCHAR(100),
  IDevice        VARCHAR(255),
  IGroup         VARCHAR(255),
  IField         VARCHAR(255),
  IValue         VARCHAR(255),
  IIcon          INT,
  IID            INT,
  ReportID       INT NOT NULL,
    
  CONSTRAINT     cnstI1 FOREIGN KEY(ReportID) REFERENCES Report(ID)
);

CREATE TABLE NextID (
  TableName      VARCHAR(6) PRIMARY KEY,
  NextID         INT NOT NULL
);

INSERT INTO NextID (TableName, NextID) VALUES ('Report', 1);
 

Error message: 

失败
警告：插入报告时出现错误！
错误：关系“item”不存在；
Error while preparing parameters
INSERT INTO Item
(INum,Ipage,IField,IValue,IIcon,IID,ReportID) VALUES (1,'报告','版本','AIDA64 v7.70.7500/cn',0,257,0)

 

The Chinese error message is translated as follows:
Failed
Warning: Error occurred while inserting report!
Error: Relation "item" does not exist;

 

I'd also like to know if the main program in AIDA64 is still 32-bit? Only some of the 64-bit test programs are 64-bit. XP is the only 32-bit operating system left, and in actual production environments, they're almost nonexistent. Even if they do exist, the number is so small that it doesn't affect data collection. When will a fully native 64-bit AIDA64 be released?

 

PostgreSQL no longer has a 32-bit version. The ODBC driver needs to have the same bitness as the main AIDA64 program. Checking in Task Manager shows that AIDA64 is 32-bit. What did I do? I first used the latest version of AIDA64 to export a CSV report, and then when I tried to import the CSV report from AIDA64's database manager, an error occurred. I tried multiple times, but the error persists. I asked AI, "Maybe AIDA64 is mixing up the uppercase and lowercase letters in the data tables. Have you tested this?" PostgreSQL databases are case-sensitive. What do I ultimately want to do? My Access database keeps getting corrupted after running for a while. I want to install PostgreSQL and, in the AD domain, use a policy to execute a command line to collect system information at startup and send it to the PostgreSQL database.