Hi All, I am faced with the problem of installing PackIn. The problem occurs when the PackOut contains a Table element, but the table already exists in the database (for example, previously added by script). The error message is "org.postgresql.util.PSQLException: ERROR: syntax error at or near "=@#" ". After diving into the code, I found that the mentioned error occurs only in native SQL mode - PostgreSQL Native=Y. IMHO, the reason for the error is the incorrect creation of a query to update existing records in the table - org.compiere.db.postgresql.provider/src/org/compiere/db/DB_PostgreSQL.java, method getSQLModify(). To simulate the error (I created a test table AH_Entity_Field), you need to run a script to create a table, and then start the PackIn installation process. Attaching: 1. Pack-Out 2. Log screen-shot 3. SQL Script for creating table
As reported by
https://groups.google.com/g/idempiere/c/UuNRuKtSmms/m/HGpKtHNIBAAJ