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.
