Syntax error while installing PackIn (native postgres)

Description

As reported by

https://groups.google.com/g/idempiere/c/UuNRuKtSmms/m/HGpKtHNIBAAJ

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

Is it worth opening a ticket in the Jira
Thanks.

Environment

None

Attachments

1

Activity

Show:
Fixed

Details

Assignee

Reporter

Fix versions

Priority

Created October 22, 2021 at 9:44 AM
Updated December 1, 2021 at 5:27 PM
Resolved October 26, 2021 at 11:06 AM