Approximate numeric datatypes include float, double precision, and real. The exact value of an approximate numeric datatype can vary from one platform to another, and this can cause replication errors.
Replicating an update or delete operation with an approximate numeric datatype causes an error if both of the following conditions are true:
The corresponding values on the primary and replicate data servers are not identical, and
No primary key constraint is defined for the table.
When no primary key constraint is defined, all columns in the table are the primary key, and any variation in the value of any column between the two databases causes an error.
For the same reason, errors occur if any column with
a primary key constraint has an approximate numeric datatype.
To prevent replication problems with approximate numeric datatypes, you must declare a primary key constraint in the primary table, and no column identified in the primary key constraint can have an approximate numeric datatype.
