Help request to fix system.db.runPrepUpdate issue

Ignition
1

pic1
pic12248×1072 184 KB

For some reason I cannot update the data table in the postgres database from the ignition script by using the system.db.runPrepUpdate function.

Would you please help me out to fix the issue

2

One thing I noted is that your table is called puplic.auto_bagger_linden_d2. Should it be public instead?

4

Aha, ok let me try to write it down in the right way

5

I fixed the issue by changing the primary key type to be “BIGSERIAL” at the database side.