Is it possible to allow Null Values in numeric fields in Camapign?

Avatar

Avatar

srikanthr646926

Avatar

srikanthr646926

srikanthr646926

18-10-2017

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. 

View Entire Topic

Avatar

Avatar

srikanthr646926

Avatar

srikanthr646926

srikanthr646926

16-11-2017

Hi florent,

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.