PostgreSQL Support for remove Space Padding

proiv dashboard

Trail: PROIV Documentation > System Services > PostgreSQL Support for Remove Space Padding

PostgreSQL support to remove trailing space padding from fields

When interacting with a PostgreSQL DB, fixed length PROIV fields are padded with trailing spaces. This means that values written to the DB are padded with trailing spaces (which may not be desirable, or may not be compatible with other processes writing to the DB); also, when comparing values in the DB, the comparison values are also padded with trailing spaces (which means they will not match values in the DB which are not similarly padded).

To address this problem a new configuration setting has been introduced:

proiv.virtualMachine.database.driver.postgres.removePadding

The space removal setting is via the dashboard.

The default value is false.

It is activated if set to true.

Then when interacting with the Data Base (DB) for writes or comparisons, then the trailing spaces will be removed.

Note: Automatic AND deliberate (any entered by the user) trailing spaces will be stripped.

Comment on this topic

Topic ID: 860006