I am observing some confusing behavior using ProIV Kernel Version 18.104.22.168-PR and Postgres 9.4.
I am doing a calculation at full precision, 6 decimal places, I can monitor the value both before and after the file write within ProIV, and it does indeed have all 6 decimal places. The postgres table is set to store only two decimal places. Everything in Postgres' documentation says that if I pass more than the set number of places, it will round off the value to the correct precision. What seems to be happening though, is that when ProIV sends the UPDATE command to Postgres, it is only passing two decimal places, not the full six. Not only is it not passing all of the digits, it seems to be truncating the number at two decimal places, not rounding it off at all.
Is there any way to control this behavior? I don't think there is any way to directly tweek the SQL command that ProIV is sending to the database, but is there perhaps a setting that will tell it to include full precision?