Just like any other database when adding columns to a huge table we are having issues if number fields is defaulted to zeros, because it is trying to update the existing records. Please let me now how we can enforce the nulls to numeric fields instead of default property.
We are having postgres as backend, the default property of the database is zero for any numeric field atleast that is how it was setup in our environemnt , please forget about the import , I am strictly talking about database here. when we add new numeric fields to a large table .. it is trying to update existing records with default value zero So instead we want the database to allow Null value, that way not updates required. It is something to do with either campaign tool which is causing the issue.
This is in v7 .We want to enforce When adding the field to schema to null value. While doing import workflow we will insert or update to default value of zero when not coming from source. So my question is how to avoid defaulting to zero when adding a new numeric field to schema